学步园

1、oracle分页

select b.* from
	(select a.*, rownum rn from emp a where rownum <10) b
	where b.rn >5;
	

select b.* from
	(select a.*, rownum rn from(
		select * from emp) a 
	where rownum <10) b
where b.rn >5;

搞不明白上面两种写法的区别，觉得还是第一种简单点。。。，希望大神来指点。

2、mysql分页

select * from emp limit start,rowCount; start ：起始行，从0开始。rowCount ，要查询出来的行数。

3、db2分页

select b.* 
	from
	(select a.*, rownumber() over(order by 1) rn from emp a) b
where b.rn between 50 and 60;