Paging query statements for various databases

1.oracle Database Paging

1 Select *  from (Select A.*fromwhere rownum<=where a.rc>= StartRow

2.DB2 Database Paging

1 Select *  from (Select over as rc,a.)* from (select*from  orderby aswherebetween and Endrow

3.SQL Server 2000 Database Paging

1 Select Top *  from where  not  inch (selecttop pagesize*  from Order  by Order  By column name

4.SQL Server 2005 Database Paging

1 Select *  from (Selectover,orderby as  where t. Column Name 1  >= and T. Column name 1<=endrow

5.MySQL Database Paging

1 Select *  from table name limit startrow,pagesize 2 (pagesize the number of records displayed per page)

6.PostgreSQL Database Paging

1 Select *  from table name limit pagesize,offset StartRow 2 (pagesize the number of records to display per page.)

7. Common mode

1 Select *  from Select *  from where  not inch (Selectfromwhere rownum<=(currentpage-1) * where <=pageSize;

Paging query statements for various databases