LIMIT

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