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
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
This article is tagged with:
Sql order by two columns
Sort by multiple column : ORDER BY column1 DESC, column2