LIMIT¶

The LIMIT clause specifies the maximum number of rows that should be returned in the result set.

Syntax¶

SELECT <column_name> [ ,... ]
FROM <table_name>
LIMIT <number_of_rows>

Parameter	Description
`column_name`	The column to retrieve
`table_name`	The table from which to retrieve the data
`number_of_rows`	The maximum number of rows to return

SELECT
  employee_id,
  employee_name
FROM
  employees
ORDER BY
  employee_id ASC
LIMIT
  10 OFFSET 20;