sqlserver 分组排序函数row_number、rank、dense_rank
分组排序函数row_number、rank、dense_rank1、row_number() over(partition by [分组列] order by [排序列])select *,row_number() over(partition by SegmentLength order by overdays)num from shield_info_reportover()函数中必须添加排序列,分组列可不添加,下同row_number()函数会按照排序列依次生成不重复的行号num...
原创
2020-08-26 10:18:21 ·
4158 阅读 ·
0 评论