mssql 指定字段编号sql语句
人气:0不错的实现数据库字段编号重排。
复制代码 代码如下:
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