语法格式:row_number() over(partition by 分组列 order by 排序列 desc)
例如:select ROW_NUMBER() OVER(ORDER BY id asc) AS xh,ID,Name from Roles
结果:
从1开始排序
语法格式:row_number() over(partition by 分组列 order by 排序列 desc)
例如:select ROW_NUMBER() OVER(ORDER BY id asc) AS xh,ID,Name from Roles
结果:
从1开始排序