分页sql语句

选择4-6的条数

t是表的别名

oracel

select  * from(select t.* , rownum rn from (select * from 表名 order by id) t where rownum<=6) where rn>=4;

mysql

select * from 表名 limit 4,6;