復制代碼 代碼如下:

select nid,ntitle,nreadtimes,Row_number() over(order by nreadtimes desc) as rownum from article