order by in sql for multiple columns code example

Example 1: 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

Example 2: sql order by multiple columns

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

Example 3: sort order on two columns sql

Sort by multiple column : ORDER BY column1 DESC, column2

Example 4: multiple order by sql

SELECT * FROM People ORDER BY FirstName DESC, YearOfBirth ASC

Tags:

Sql Example