What does LIMIT 10 do in a query?

A Returns only the first 10 rows of the result set B Filters rows where a value is less than 10 C Stops execution after 10 seconds D Restricts the query to 10 tables