LIMIT

Anonymous contributor
Anonymous contributor
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

Looking to contribute?

Learn SQL on Codecademy