SQL multiple column ordering

Question

I am attempting to sort by multiple columns in SQL, and in different directions. column1 would be sorted descending, and the column2 would be sorted ascending.

How can I able to do it?

Answer 1

You can try the below code:

ORDER BY column1 DESC, column2

This will be sorting everything by column1 (in the descending order) first, and then by column2 (in the ascending order, which will be the default) whenever it is seen that the column1 fields for two or more number rows are equal.

Become a SQL expert with this complete SQL Training Course!