oracle学习记录,分页的查询语句。使用差运算minus。查询结果显示第二页。
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;
oracle学习记录,分页的查询语句。使用差运算minus。查询结果显示第二页。
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;