Oracle:
SELECT *
FROM (SELECT tt.*, ROWNUM As row_num
FROM () tt
WHERE ROWNUM <= 100) tab
WHERE tab.row_num >= 1
Mysql:
select * from tab limit 1,5
Oracle:
SELECT *
FROM (SELECT tt.*, ROWNUM As row_num
FROM () tt
WHERE ROWNUM <= 100) tab
WHERE tab.row_num >= 1
Mysql:
select * from tab limit 1,5