分页

SELECT * FROM (
  SELECT u.*,ROWNUM rn FROM (SELECT * FROM userinfo)u
  WHERE Rownum<=5)
WHERE rn>=4;




select T1.* from ( 
      select T2.* ,rownum row_id from (select T3.* from (SELECT * FROM userinfo)T3 order by T3.userid ASC)T2  
)T1  where T1.row_id >4 and  T1.row_id < 5;