Published Jun 4, 2021Updated Sep 3, 2021
Contribute to Docs
Specifies, or limits, the maximum number of rows the result set will have.
SELECT column_name(s)FROM table_nameLIMIT 20;
The given query will limit the result set to 5 rows from the
SELECT *FROM moviesLIMIT 5;
- Anonymous contributorAnonymous contributor
- Anonymous contributor
Looking to contribute?
- 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
Analyze Data with SQLLearn to analyze data with SQL and prepare for technical interviews.
Includes 8 Courses
Design Databases With PostgreSQLLearn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses