取前20条用第一个就够了 如果是第 m到n条则这样SELECT NAME, NUM FROM ( SELECT NAME, NUM,ROWNUM AS SRUM FROM ( SELECT NAME, NUM FROM USERMESS ORDER BY NUM DESC ) where rownum < n )WHERE SRUM > m;
SELECT NAME, NUM FROM (SELECT a.*,ROWNUM AS RSUM FROM ( SELECT NAME, NUM FROM USERMESS ORDER BY NUM DESC ) a)WHERE RSUM<M AND RSUM >=N;
如果是第 m到n条则这样SELECT NAME, NUM FROM (
SELECT NAME, NUM,ROWNUM AS SRUM FROM
( SELECT NAME, NUM FROM USERMESS ORDER BY NUM DESC ) where rownum < n )WHERE SRUM > m;