MySQL-limit the number of returned records (limit)

SELECT * FROM TableLIMIT[Offset,]Rows|Rows OFFSET offset

The LIMIT clause can be used to force the SELECT statement to return the specified number of records. LIMIT accepts one or two numeric parameters. The parameter must be an integer constant. If two parameters are specified, the first parameter specifies the offset of the first returned record row, and the second parameter specifies the maximum number of returned record rows. The OFFSET of the initial record row is 0 rather than 1. To be compatible with PostgreSQL, MySQL also supports Syntax: LIMIT # OFFSET #.

SELECT*FROM TableLIMIT 2 OFFSET 1;

For example, in this SQL statement, two pieces of data are followed by the limit statement, and the offset statement is followed by 1st pieces of data.

SELECT*FROM TableLIMIT 2, 1;

In this SQL statement, limit reads one message starting from 2nd.

SQL statement for querying the latest records:

SELECT*FROM TableOrderTime descLIMIT n;

For Oracle, rownum can be used to implement the same functions.