mssql 指定字段编号sql语句

数据运维 2023-04-16 Escape 手机阅读

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

                        <p>复制代码 代码如下:select nid,ntitle,nreadtimes,Row_number() over(order by nreadtimes desc) as rownum from article <img alt src="http://img.558idc.com/uploadfile/allimg/210405/12222I626-0.gif"></p>