sqlserver及oracle的分页

sqlserver:

select top pageSize * from tableName

where (ID > (

select isnull(MAX(id),0) from (

select top pageSize_curPage id from  tableName  order by ID

) as T)

) order by ID 

 

 

 

 

 

 

oracle:

select rn,id from (

select rownum as rn  from 

(select * from tableName order by id) where rownum <= pageSize*curPage )

where rn >= (pageSize*(curPage-1) + 1)) 

 

 

 

pageSize_curPage为pageSize*(curPage-1)的值