mysql: select * from user order by desc limit n ,m.
表示，從第n條數(shù)據(jù)開始查找，一共查找m條數(shù)據(jù)。
Oracle：select * from user select rownum a * from ((select * from user)a) select * from (select rownum a.* from (select * from user) a ) where r between n , m .
