ORDER BY DESC

How can we show the highest salaries first?

Beginner⏱ 3 Minutes⭐ 670 XP

🤔 THE QUESTION

How can we show the highest salaries first?

💡 WHAT IS IT?

The DESC keyword reverses sorting order from highest to lowest or Z to A.

🎯 WHAT IS IT USED FOR?

Leaderboards, finding recent timestamps, top compensation analysis.

💻 EXAMPLE

SELECT name, salary
FROM employees
ORDER BY salary DESC;

Practice typing production-grade SQL code for ORDER BY DESC.