asc 按升序排列
desc 按降序排列
方法一(两层查询):
select uuid, userid, username
from (select rownum r, uuid, userid, username from tbl_sysuser)
where r >= 2
and r < 4
方法二(三层查询):
SELECT *
FROM (SELECT A.*, ROWNUM RN
FROM (SELECT * FROM tbl_sysuser where 1=1 ) A
WHERE ROWNUM < 4)
WHERE RN >= 2