//单表分页
start_num 起始行号
end_num 截止行号
SELECT t.*
FROM (SELECT s.*,rownum rn
FROM table s
WHERE rownum <= end_num) t
WHERE rn >= start_num
//多表分页
SELECT *
FROM (SELECT temp.*, ROWNUM num
FROM (SELECT table_a.*, table_b.*
FROM table_a a,
table_b b
WHERE a.id = b.id) temp
where ROWNUM <= end_num) WHERE num > start_num