LIMIT
The LIMIT modifier can be used after the WHERE clause to return a specific number of results.
For example, the following query shows the 10 highest-grossing films that are part of a series.
Note that the GROUP BY modifier only works with an aggregate function (such as COUNT). The modifiers ORDER BY and LIMIT do not require an aggregate function.