1、显示前5条记录
当前所在页(currentPage)为1;
每页显示的记录长度(lineSize)为temp;
SELECT *
FROM (SELECT rownum rb, emp.* from emp where rownum <= 5) temp
WHERE temp.rb > 0
2、显示中间的5条记录
当前所在页(currentPage)为2;
每页显示的记录长度(lineSize)为temp;
SELECT *
FROM (SELECT rownum rb, emp.* from emp where rownum <= 10) temp
WHERE temp.rb > 5
3、显示第三页的5条记录
当前所在页(currentPage)为3;
每页显示的记录长度(lineSize)为temp;
SELECT *
FROM (SELECT rownum rb, emp.* from emp where rownum <= 15) temp
WHERE temp.rb > 10