LIMIT is commonly used for:
- Retrieving the top N records (e.g., top 10 highest scores)
- Pagination (showing a limited number of results per page)
- Performance optimization (limiting results for large tables)
- Preview data (quickly seeing a sample of results)