编写数据库查询分页SQL

假设每页显示X条，用pagesize表示；当前要显示第X页，用currentPage表示；
SQLServer中：

select top pagesize * from tablename
where id not in (select top (currentPage-1)*pagesize id from tablename)

select top pagesize * from
(select ROW_NUMBER() over (order by id asc) as rownumber, * from (select * from tablename) as oo) as o
where rownumber > (currentPage-1)*pagesize

mysql中：

select * from tablename limit (currentPage-1)*pagesize,pagesize

Oracle中：

select *  from (select rownum rn,t.* from tablename ) t
where t.rn>(currentPage-1)*pagesezie and t.rn<=currentPage*pagesezie