Sql order by two columns

This article is tagged with: Sql order by two columns and mysql

order by with more than one column

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

sql order by two columns

ORDER BY column1 DESC, column2

sort order on two columns sql

Sort by multiple column : ORDER BY column1 DESC, column2

This article is tagged with: Sql order by two columns and mysql