multiple order by sql
snippet in sql

multiple order by sql

user7383

ORDER BY column1 DESC, column2

order by with more than one column

user3012

The following shows that you can perform order by with more
than one column.
'ASC' denotes ascending sort order, but is optional as it is the default sort order.
'DESC' denotes descending sort order

SELECT Id, CompanyName, City, Country  
FROM Supplier 
WHERE Country IN ('USA', 'Japan', 'Germany') 
ORDER BY Country ASC, CompanyName DESC

sort order on two columns sql

user822

Sort by multiple column : ORDER BY column1 DESC, column2

sql order by two columns

user9372

ORDER BY column1 DESC, column2