mysql,oracle的分页查询

mysql,oracle的分页查询

mysql:

select empno,ename from students limit 0,10;  1-10条记录
select empno,ename from students limit 10,10; 11-20条记录
select empno,ename from students limit 20,10; 21-30条记录

带条件的分页查询

select empno,ename from students where age=16 limit 20,10;

oracle:

select A.id,A.name,A.age
from (select rownum B,student.* from student where rownum<7)A
where B>3;

子查询中，rownum必须取别名且不能和列名（字段名）相同，where后面必须用rownum的别名，整个子查询用A表示。

带条件的分页查询

oracle:
select A.id,A.name,A.age
from (select rownum B,student.* from student where age=16 and rownum<7 )A
where B>3;