如下语句:
select row_number() over ( order by itmcode) as sequance,itmcode from table1 select row_number() over ( order by it
select row_number() over ( order by itmcode) as sequance,itmcode from table1 select row_number() over ( order by it
阅读背景：
sql server row_number()函数每个组从1开始
来源：互联网
分享到：
