1、根据某列排序。
SELECT ROW_NUMBER() OVER (ORDER BY column_name) AS RowNum
2、避免排序
select ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
sqlserver查询获取行号
最新推荐文章于 2024-05-30 19:46:53 发布
1、根据某列排序。
SELECT ROW_NUMBER() OVER (ORDER BY column_name) AS RowNum
2、避免排序
select ROW_NUMBER() OVER (ORDER BY (SELECT NULL))