LIMIT

How can we return only the first few rows?

Beginner⏱ 3 Minutes⭐ 710 XP

🤔 THE QUESTION

How can we return only the first few rows?

💡 WHAT IS IT?

LIMIT constrains the maximum number of rows returned by the database engine.

🎯 WHAT IS IT USED FOR?

Pagination, previewing query results, high-performance sampled analytics.

💻 EXAMPLE

SELECT name, salary
FROM employees
ORDER BY salary DESC
LIMIT 10;

Practice typing production-grade SQL code for LIMIT.