当前位置: 数据库>sqlserver
mssql 指定字段编号sql语句
来源: 互联网 发布时间:2014-09-05
本文导语: 代码如下: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