select * from (select *, rownum rowid from tablename where rownum<page*size)where rowid >=(page-1)*size