mssql 指定字段编号sql语句

复制代码 代码如下: select nid,ntitle,nreadtimes,Row_number() over(order by nreadtimes desc) as rownum from article

复制代码 代码如下:select nid,ntitle,nreadtimes,Row_number() over(order by nreadtimes desc) as rownum from article