Detailed explanation and options for the selected question.
LIMIT restricts the number of rows returned by a query. WHERE filters rows, GROUP BY groups rows, and ORDER BY sorts them.