不錯的實現(xiàn)數(shù)據(jù)庫字段編號重排。
代碼如下:
select nid,ntitle,nreadtimes,Row_number() over(order by nreadtimes desc) as rownum from article
? 版權(quán)聲明
文章版權(quán)歸作者所有,未經(jīng)允許請勿轉(zhuǎn)載。
THE END
不錯的實現(xiàn)數(shù)據(jù)庫字段編號重排。
代碼如下:
select nid,ntitle,nreadtimes,Row_number() over(order by nreadtimes desc) as rownum from article