MYSQL paging keyword (limit)

MySQL Paging keywords:

　　 limit m,n--m: Indicates the line from which to start, N: Query how many bars

Oracle Paging Keyword:: rownum

SQL Server:top(under 2005 versions)
　　　　　 row_number ()(2005 later version)

Query the first 10 data:

SELECT *  from 0,ten  # #查询出前十条的数据从0开始

You can also write this:

SELECT *  from ten;  # #查询出前十条数据

Check out the following 5 data from the 6th article:

SELECT *  from 5,5   # #从第六条开始查五条数据

Oracle:rownum page Usage

SELECT *  from (SELECT PD.*  , rownum num         from the products  PD        WHERE RowNum<=WHERE num>            

MYSQL paging keyword (limit)