oracle分页和MySQL分页

-- oracle分页
select 
    * 
from 
    (select rownum rn,t.* from table_Name t ) r 
where 
    r.rn between (pageNo-1)*pageSize+1 and pageNo*pageSize;
​
-- MySQL分页 N 起始条数  M 展示数量 
select 
    * 
from 
    table_Name t 
where 
    limit N,M

​