Oracle分页查询

因为在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

参考链接：http://blog.csdn.net/fw0124/article/details/42737671