公式:
SELECT *
FROM DATA_SOURCE_TABLE AS A
WHERE (SELECT COUNT(1) FROM DATA_SOURCE_TABLE B WHERE A.GROUP_FIELD = B.GROUP_FIELD AND A.ORDER_BY_FIELD < B.ORDER_BY_FIELD) <= N
ORDER BY A.GROUP_FIELD, A.ORDER_BY_FIELD DESC
注:DATA_SOURCE_TABLE A 和 DATA_SOURCE_TABLE B 为同一个表
N为前几名