MySQL LIMIT

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