(1)SELECT A.*,ROW_NUMBER() OVER (PARTITION BY ISSUE_ENTERPRISE_ID ORDER BY C_INDEX DESC, ADD_TIME DESC) ROW_NUM
FROM TEST AORDER BY ROW_NUM ASC, C_INDEX DESC, ADD_TIME DESC
ISSUE_ENTERPRISE_ID 是需要分组的字段 ,C_INDEX DESC, ADD_TIME DESC)排序字段 , ROW_NUM 编号 每个分组实现一个编号数字1.2.3、、、、
(2)
SELECT B.id FROM (SELECT A.*,ROW_NUMBER() OVER (PARTITION BY ISSUE_ENTERPRISE_ID ORDER BY C_INDEX DESC, ADD_TIME DESC) ROW_NUM
FROM TEST A
ORDER BY ROW_NUM ASC, C_INDEX DESC, ADD_TIME DESC) B WHERE ROW_NUM < 11 AND ROWNUM <11
要取前10条数据的ID ROWNUM <11 ,ROW_NUM < 11 可能分组字段不足10条 循环取10条 至多可能需要编号ROW_NUM=10