具有比较值的栗子如下,如果不具有比较值,则使用统计总数,生成比较值
SELECT a.person, a.group, a.age FROM person AS a WHERE
(SELECT COUNT(*) FROM person AS b
WHERE b.group = a.group AND b.age >= a.age) <= 2
ORDER BY a.group ASC, a.age DESC
生成比较值
SELECT a.*
FROM (select depart_id,bu_id,login_name, count(1) total from data id group by depart_id,bu_id order by total desc)a
WHERE
(SELECT COUNT(*) FROM (select depart_id,bu_id,login_name, count(1) total
from data id group by depart_id,bu_id order by total desc)b
WHERE b.depart_id = a.depart_id and b.total >= a.total
) <= 3;