weixin_45317112的博客

原创 sqlserver 分组排序函数row_number、rank、dense_rank

分组排序函数row_number、rank、dense_rank 1、row_number() over(partition by [分组列] order by [排序列]) select *,row_number() over(partition by SegmentLength order by overdays)num from shield_info_report over()函数中必须添加排序列，分组列可不添加，下同 row_number（）函数会按照排序列依次生成不重复的行号num...