sql server 查询时增加一个自增长列

xiaoxiao2021-02-28  99

Row_Number() over ( id asc )  

select Row_Number() over ( 列名  asc ),name,description from 表名

select Row_Number() over ( order by 列名 ) as init , * from  表名

转载请注明原文地址: https://www.6miu.com/read-24516.html

最新回复(0)