LIMIT

christian.dinh's avatar
christian.dinh's avatar
christian.dinh
Published Jun 4, 2021Updated Sep 3, 2021
Contribute to Docs

Specifies, or limits, the maximum number of rows the result set will have.

Syntax

SELECT column_name(s)
FROM table_name
LIMIT 20;

Example

The given query will limit the result set to 5 rows from the movies table.

SELECT *
FROM movies
LIMIT 5;

All contributors

Contribute to Docs

Learn SQL on Codecademy