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_nameLIMIT 20;
Example
The given query will limit the result set to 5 rows from the movies
table.
SELECT *FROM moviesLIMIT 5;
Contribute to Docs
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.
Learn SQL on Codecademy
- Skill path
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.Includes 9 CoursesWith CertificateBeginner Friendly17 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 CoursesWith CertificateBeginner Friendly13 hours - 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 Friendly5 hours