SQL LIMIT

Published Jun 4, 2021Updated Sep 3, 2021

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

Skill path
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.
Includes 9 Courses
With Certificate
Beginner Friendly.
17 hours
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.
13 hours

Syntax

SELECT column_name(s)
FROM table_name
LIMIT 20;

Copy to clipboardCopy to clipboard

Example

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

SELECT *
FROM movies
LIMIT 5;

Copy to clipboardCopy to clipboard

All contributors

christian.dinh
Anonymous contributor

Learn SQL on Codecademy

Skill path
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.
Includes 9 Courses
With Certificate
Beginner Friendly.
17 hours
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.
13 hours