数据库分页测试

 

Oracle (11g) Failed:
select * from (select * from dept where rownum <=6) where rownum >=4
select * from dept where rownum <=6 and rownum >=4

SQL Server OK:
select top 3 * from dept where did not in (select top 3 did from dept);
select top 3 * from Students where id not in (select top 3 id from Students);

MySQL OK:
select * from Students where order by id limit 3,3;