sql语句分页

Oracle 分页SQL

select s.* from (select rownum as r,t.* from dept t where rownum <4) s where s.r>1

 

MySQL分页SQL

select * from table_name  limit m,n;