SQL multiple column ordering

Question

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

How can I do this?

Answer 1

Try this code:

ORDER BY column 1 DESC, column 2

The above code sorts everything by column 1 (in descending order) first, and then by column 2 (in ascending order, which will be done by default), it happens whenever the column 1 fields for two or more rows are equal.