因为在oracle中没有limit语句,不能像在mysql中那样用limit进行分页查询
Oracle中通过rownum进行分页查询
//对uuid进行排序并分页查询 其中uuid为主键
select uuid, queryno, phone from
(select a.uuid, a.queryno, a.phone, rownum row_num from
(select uuid, queryno, phone from GW3_INTERACTIVE order by uuid asc)a
where rownum <=20
)b
where b.row_num >= 10