How do I use ORDER BY in SQL?

How do I use ORDER BY in SQL?

You can use the ORDER BY clause to sort the result set of a query by one or more columns. For example: SELECT * FROM employees ORDER BY last_name ASC; This will sort the employees by their last names in ascending order.

Can I sort by multiple columns?

Yes, you can sort by multiple columns by separating them with commas. For example: SELECT * FROM employees ORDER BY department ASC, last_name DESC; This will sort first by department in ascending order and then by last name in descending order.

What if I want to sort in descending order?

You can specify descending order by using the DESC keyword. For example: SELECT * FROM products ORDER BY price DESC; This will sort the products by price from highest to lowest.

Is it possible to sort by calculated fields?

Yes, you can sort by calculated fields. For example: SELECT name, salary * 1.1 AS adjusted_salary FROM employees ORDER BY adjusted_salary DESC; This will sort employees by their adjusted salary.