先查出rownum,并添加别名 row_id,查出小于limit的量,然后在截取大于limit的量。
SELECT * FROM (
SELECT TMP_PAGE.*, ROWNUM ROW_ID FROM (
SELECT sessionId, login_name, expire_time
FROM sys_user_online
order by last_access_time desc ) TMP_PAGE
WHERE ROWNUM <= ? )
WHERE ROW_ID > ?