2. 分组聚合函数：ROW_NUMBER() OVER (PARTITION BY Column ORDER BY COLUMN

SQLServer版本至少2005版

语法:

ROW_NUMBER() OVER (PARTITION BY Column1 ORDER BY COLUMN2)

• Column1: 分组列
• Column2：排序列

演示：

1.创建如下表Table_1结构并插入数据：

2.执行SQL：

select *,ROW_NUMBER() OVER (PARTITION BY kysl ORDER BY KYSL2 )ws from [Table_1] 

结果如下：