正序列号
select ROW_NUMBER() over(order by Id) as xh,Id,Name,TelNumber,Zhijin from Users1反序列号
select 序号=(select count(1) from Xuhao a where a.Id>=Xuhao.Id),* from Xuhao本文共 216 字，大约阅读时间需要 1 分钟。
正序列号
select ROW_NUMBER() over(order by Id) as xh,Id,Name,TelNumber,Zhijin from Users1反序列号
select 序号=(select count(1) from Xuhao a where a.Id>=Xuhao.Id),* from Xuhao转载于:https://www.cnblogs.com/Dingcps/p/9353569.html