What is the purpose of the LIMIT clause in MySQL?
How do you retrieve only the first 5 rows from a table named products?
What happens if you use a LIMIT clause with a number larger than the number of rows in the table?
How can you use the LIMIT clause to retrieve rows starting from a specific offset?
What is the purpose of combining LIMIT with the ORDER BY clause?
How do you retrieve the second page of results if each page shows 10 rows?
Explain how you would use LIMIT in a subquery within a larger query.
How can the LIMIT clause affect the performance of a query in large datasets?
Describe a scenario where using LIMIT could lead to inconsistent results in concurrent environments.
During a database certification exam, you are asked to write a query that retrieves the 11th to 20th highest scores from a scores table. What would your query look like?