LIMIT

Defines the maximum number of rows returned by a statement or subquery to n.

Syntax

SELECT ...
  FROM ...
    [ORDER BY]
    LIMIT n
[ ... ]

Parameters

n: A non-negative integer.

Usage Notes

Without the optional ORDER BY clause, the results are non-deterministic and do not necessarily follow a specific order.

Example

SELECT * FROM (SELECT 'a' AS ord1, 'g1' AS grp1, '10' AS col1
                     UNION ALL 
                     SELECT 'b' AS ord1, 'g1' AS grp1, '20' AS col1
                     UNION ALL
                     SELECT 'c' AS ord1, 'g1' AS grp1, '20' AS col1
                     UNION ALL 
                     SELECT 'a' AS ord1, 'g2' AS grp1, '30' AS col1
                     UNION ALL 
                     SELECT 'b' AS ord1, 'g2' AS grp1, '30' AS col1
                     UNION ALL 
                     SELECT NULL AS ord1, NULL AS grp1, NULL AS col)
          ORDER BY ord1 
          LIMIT 3;

+------+------+------+
| ORD1 | GRP1 | COL1 |
+------+------+------+
| a    | g1   | 10   |
| b    | g1   | 20   |
| c    | g1   | 30   |
+------+------+------+