Database Mysql-oracle-db2-sqlserver Paging Query

1. mysql Paging query

(1) Keyword: LIMIT beginindex, MaxRow

(2) Example:

The limit clause can be used to limit the amount of data returned by the SELECT statement, which has one or two parameters. If two arguments are given, the first parameter specifies the position of the first row returned in all data, starting with 0 (note not 1), and the second parameter specifies the maximum number of rows to return . For example:

-- starting from Beginindex line, query MaxRow row Select *  from Table Limit Beginindex,maxrow -- starting with 10 rows, query 20 rows, that is, query 10~30 rows of data Select *  from Table Ten,

--return to the first 10 rowsSelect *  from Table WHERE... LIMITTen; --return to the first 10 rowsSelect *  from Table WHERE... LIMIT0,Ten;--return 第10-30 rows of dataSelect *  from Table WHERE... LIMITTen, -;

2. Oracle Paging Query
3. DB2 paging Query 4. SQL Server Paging Query

Database Mysql-oracle-db2-sqlserver Paging Query