JZTXT

Sql Server分组排序及生成序列号

发布时间 2023-09-20 14:30:38作者: 常威打来福
1 --1.分组排序
2 SELECT *,ROW_NUMBER() OVER(PARTITION BY @fileName,@fileName1 ORDER BY ID DESC) AS rowNum  FROM @tableName 
3 
4 --2.生成序列号
5 SELECT *,ROW_NUMBER() over(order by id ASC)  AS rowNum FROM @tableName