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
Test