常用数据库分页

oracle分页sql

select page2.* from (
select page1.* ,rownum as sds from 
(
    select * from NX_SYS_PREVAL_P --oracle分页的sql
) page1
where rownum<8
)page2 where page2.sds>3;

mysql分页sql

select * from  NX_SYS_PREVAL_P
where (xxx and ddd) or dfd
limit 3,5