LIMIT
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;
Contributors
- Anonymous contributors