实现代码如下：
select nid,ntitle,nreadtimes,Row_number() over(order by nreadtimes desc) as rownum from article
以上就是【mssql 指定字段编号sql语句】的全部内容了,欢迎留言评论进行交流!
select nid,ntitle,nreadtimes,Row_number() over(order by nreadtimes desc) as rownum from article