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

Skill path

Analyze Data with SQL

Learn to analyze data with SQL and prepare for technical interviews.
Includes 8 Courses
With Certificate
Beginner Friendly
15 Lessons
Skill path

Design Databases With PostgreSQL

Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses
With Certificate
Beginner Friendly
11 Lessons
Free course

Learn SQL

In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.
Beginner Friendly
4 Lessons