orcale分页查询

admin

select *from (


select t.*,ROWNUM RN  from LJACCOUNT t

)   where RN between  19 and 21

admin

SELECT *
FROM ( SELECT t.*,
       ROWNUM rn
       FROM LJACCOUNT t
       WHERE ROWNUM <= 10 )
WHERE rn > 0;



SELECT t.*,  ROWNUM rn        FROM LJACCOUNT t   WHERE ROWNUM <= 10