SELECT * FROM (SELECT 分组的字段名,ROW_NUMBER() OVER(PARTITION BY 分组的字段名 ORDER BY 排序的字段名) AS RN FROM 表名) WHERE RN <= 10原文链接：https://www.f2er.com/oracle/209274.html
SELECT * FROM (SELECT 分组的字段名,ROW_NUMBER() OVER(PARTITION BY 分组的字段名 ORDER BY 排序的字段名) AS RN FROM 表名) WHERE RN <= 10原文链接：https://www.f2er.com/oracle/209274.html
