oracle学习记录之分页
oracle学习记录,分页的查询语句。
www.2cto.com
使用差运算minus。查询结果显示第二页。
[sql]
select rownum, first_name from hr.employees where rownum between 1 and 40
minus
select rownum,first_name from hr.employees where rownum between 1 and 20;