Interview Question

What is ORDER BY?

ORDER BY is required when a query needs a defined result order.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

ORDER BY sorts the final query result by one or more expressions. • ASC requests ascending order and DESC requests descending order. • Later sort expressions break ties from earlier expressions. • Without ORDER BY, row order is not guaranteed.

💡 SQL Example

SELECT name, salary FROM employees ORDER BY salary DESC, name ASC;

Result

Maya | 60000
Asha | 55000

⚡ Quick Revision

ORDER BY is required when a query needs a defined result order.

←

PreviousWhat is WHERE clause?

NextWhat is GROUP BY?

→