LIMIT

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;
Edit this page on GitHub

Contributors

Interested in helping build Docs? Read the Contribution Guide or share your feedback.

Learn SQL on Codecademy

Edit this page on GitHub

Contributors