语法格式:row_number() over(partition by 分组列 order by 排序列 desc)
SELECT
ROW_NUMBER() OVER(PARTITION BY sh.BUSMAIINFID ORDER BY nvl(sh.TIMESTAMP, sh.CREATEDATE) DESC)AS RN,
sh.ORGID,
sh.BUSMAIINFID,
sh.TIMESTAMP,
sh.CREATEDATE
FROM
REG_NETREGINFOACC sh
WHERE
sh.BUSITYPE IN ('20', '25', '12')
AND sh.state
IN ('01', '02')
结果