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

After each column name in your ORDER BY clause, you can specify DESC for descending. You can also specify ASC for ascending, but this is the default. For example, if you want to order your result set by player name in ascending order and then by points scored in descending order, use:

SELECT *

FROM player

ORDER BY player_name ASC, points_scored DESC;