语法格式:row_number() over(partition by 分组列 order by 排序列 desc)
SELECTROW_NUMBER() OVER(PARTITION BY sh.BUSMAIINFID ORDER BY nvl(sh.TIMESTAMP, sh.CREATEDATE) DESC)AS RN,sh.ORGID,sh.BUSMAIINFID,sh.TIMESTAMP,sh.CREATEDATE
FROMREG_NETREGINFOA…
背景 数据如上,按id和ssny分组,求最大的开票时间,若为空,取非空的上一期组内最大开票时间 解
SELECT
id,
ssny,
kpsj,
max(kpsj) OVER(PARTITION BY id ORDER BY ssny desc ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) …