How do you use the ORDER BY clause to sort query results in ascending and descending order?

Question

Aryan Kumar · Answer

The ORDER BY clause in SQL is used to sort the results of a SELECT statement. By default, the ORDER BY clause sorts the results in ascending order. To sort the results in descending order, you can use the DESC keyword.

For example, the following SELECT statement will return all of the rows from the customers table, sorted by the customer_name column in ascending order:

SQL

SELECT * FROM customers ORDER BY customer_name;

To sort the results in descending order, you can use the following SELECT statement:

SQL

SELECT * FROM customers ORDER BY customer_name DESC;

You can also sort the results by multiple columns. To do this, you simply specify the names of the columns, separated by commas, in the ORDER BY clause. For example, the following SELECT statement will return all of the rows from the customers table, sorted by the customer_name column in ascending order, and then by the customer_id column in ascending order:

SQL

SELECT * FROM customers ORDER BY customer_name, customer_id;

You can also specify the direction of sorting for each column. To do this, you can use the ASC keyword for ascending order or the DESC keyword for descending order. For example, the following SELECT statement will return all of the rows from the customers table, sorted by the customer_name column in descending order, and then by the customer_id column in ascending order:

SQL

SELECT * FROM customers ORDER BY customer_name DESC, customer_id;

forum

How do you use the ORDER BY clause to sort query results in ascending and descending order?

Can you answer this question?

1 Answers