mysql select * from tb limit 0,5; select * from tb limit (当前页码-1)*每页条数,每页条数; oracle 在Oracle中只能用子查询来做分页 select * from (select tb.*,rownum rn from tb) where rn between 1 and 5; mysql从0开始计算页码,oracle从1开始