mysql 分组取指定条数的数据

在数据条数不足的情况未测试:

表结构如下:

刘德华,周润发,未命名三个分组,每组三条数据

实现三个分组,每组取一条数据

SQL如下:

SELECT
	*
FROM
	(
		(
			SELECT
				g.id,
				g.project_id,
				g.group_name,
				g.group_user_id,
				ug.user_name
			FROM
				t_group g,
				t_user_group ug
			WHERE
				g.id = ug.group_id
		)
	) m
WHERE
	1 > (
		SELECT
			count(*)
		FROM
			(
				SELECT
					g.id,
					g.project_id,
					g.group_name,
					g.group_user_id,
					ug.user_name
				FROM
					t_group g,
					t_user_group ug
				WHERE
					g.id = ug.group_id
			) n
		WHERE
			n.group_user_id = m.group_user_id
		AND n.id < m.id
	)
ORDER BY
	group_user_id