随笔分类 -  sqlserver

sql 分组根据每组内部排序后的每组连续唯一的顺序编号
摘要：select row_number() over (partition by 分组字段 order by 排序字段) as 序号，表现出的是组内连续不唯一的序号，select * from (select row_number() over (order by 排序字段 desc) as rowid... 阅读全文
posted @ 2015-11-10 11:02 木子无音 阅读(545) 评论(0) 推荐(0)