SQL multiple column ordering

Question

I am trying to sort to multiple columns in SQL, and in different directions. coloumn1 would be sorted decending, and coloumn2 accending.

How can I do this?

Answer 1

ORDER BY column1 DESC, column2

Answer 2

SELECT  *
FROM    mytable
ORDER BY
        coloumn1 DESC, coloumn2 ASC