MySQL LIMIT
Last Updated: March 11, 2022
You can limit the number of results of the result set
The following query will return all matching records from the database
SELECT name FROM employees WHERE age > 40
With LIMIT
keyword you can limit the recordset
SELECT name FROM employees WHERE age > 40 LIMIT 10