LIMIT
Anonymous contributor
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_nameLIMIT 20;
Example
The given query will limit the result set to 5 rows from the movies
table.
SELECT *FROM moviesLIMIT 5;
All contributors
- 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.