SELECT DISTINCT id FROM tb WHERE id IN(
SELECT id AS NUM FROM tb GROUP BY id ORDER BY NUM DESC
) LIMIT 0,10
SELECT DISTINCT id FROM tb WHERE id IN(
SELECT id AS NUM FROM tb GROUP BY id ORDER BY NUM DESC
) LIMIT 0,10
转载于:https://my.oschina.net/LinuxDaxingxing/blog/889619