各数据库的分页SQL语句

==================================================================

oracle 

以scott.emp表准。oracle 一共有三种分页方法 

1.select * from (select * from (select rownum rn, a1.* from (select * from emp order by sal desc) a1 ) where rn > 10 and rn < 20)      效率最佳

2.select * from (select a1.*, row_number() over ( order by sal desc) ri from emp a1) where ri > 10 and ri <20     效率中等

3.select * from (select a1.*,rownum rn from (select * from emp order by sal desc) a1) where rn >10 and rn <20;       效率最差