Oracle中ROW_NUMBER() OVER(PARTITION BY Xxx ORDER BY Xxx ASC|DESC)的用法
ROW_NUMBER() OVER(PARTITION BY 字段名1 ORDER BY 字段名2 )
上面的意思就是将查询结果按照‘字段名1’字段分组(partition)
然后组内按照‘字段名2’字段排序
然后为每行记录返回一个rownumber用于标记顺序
常用:
SELECT T.*, ROW_NUMBER() OVER (PARTITION BY T.FIELD1 ORDER BY T.FIELD2) ROW_NUM
FROM TABLE1 T