multiple order by sql

1SELECT * FROM People ORDER BY FirstName DESC, YearOfBirth ASC
2

1The following shows that you can perform order by with more
2than one column.
3'ASC' denotes ascending sort order, but is optional as it is the default sort order.
4'DESC' denotes descending sort order
5
6SELECT Id, CompanyName, City, Country  
7FROM Supplier 
8WHERE Country IN ('USA', 'Japan', 'Germany') 
9ORDER BY Country ASC, CompanyName DESC

1SELECT * FROM table_name ORDER BY col1 ASC;				-- ASCending is default
2SELECT * FROM table_name ORDER BY col1 DESC;			-- DESCending
3SELECT * FROM table_name ORDER BY col1 DESC, col2;		-- col1 DESC then col2 ASC

1ORDER BY column1 DESC, column2

1Sort by multiple column : ORDER BY column1 DESC, column2

1ORDER BY column1 DESC, column2
2