Sql Server分组排序及生成序列号
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
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
