--MySql
select * from biaoming where tiaojian limit num1(start),num2(size)</span>
--Oracle
关键字rownum
--按照入职时间的顺序,查询从第7个到第10个人select t2.*
from (select t1.*, rownum rn
from (select * from emp order by hiredate) t1
where rownum <= 10) t2
where rn >= 7;