oracle分页查询

来源:互联网 发布:mysql select as 用法 编辑:程序博客网 时间:2024/05/22 02:10
select * from (select *, rownum rowid from tablename where rownum<page*size)where rowid >=(page-1)*size