第1个回答 2013-07-25
这是oracle 的分页语法
select username, sex, age, email,address, reg_date from users :查询的语句
select e.*,rownum rn from (select username, sex, age, email,address, reg_date from users)e where rownum <=?
取 ? 行以内的数据
select * from (select e.*,rownum rn from (select username, sex, age, email,address, reg_date from users)e where rownum <=?) where rn>=?
取 rn>=? 以上的数据