ORDER BY

How can we sort query results in ascending or descending order?

Beginner⏱ 2 Minutes⭐ 150 XP

🤔 THE QUESTION

How can we sort query results in ascending or descending order?

💡 WHAT IS IT?

ORDER BY sorts the returned rows by one or more specified columns in ASC or DESC direction.

🎯 WHAT IS IT USED FOR?

Creating leaderboards, sorting by latest dates, organizing records by numeric value.

💻 EXAMPLE

SELECT *
FROM employees
ORDER BY salary DESC;

Practice typing production-grade SQL code for ORDER BY.