分页语句Sql

下面是主流的三种数据库的分页sql

sql server:

         String sql =

          "select top " + pageSize +" * from students where id not in" + "(select top " + pageSize *(pageNumber-1) + " id from students order by id)" + "order by id";

 

mysql:

 

         String sql ="select * from students order byid limit " + pageSize*(pageNumber-1) + "," + pageSize;

        

oracle:

 

         String sql =  "select * from " + 

          (select *,rownum rid from (select * fromstudents order by postime desc) where rid<=" + pagesize*pagenumber +") as t" +

           "where t>" +pageSize*(pageNumber-1);