Hello everyone, I am going to share the code
sample for order by multiple columns using SQL Server. The detail about it as
given below.
The Table of Content for order by multiple
columns.
- Syntax for order by multiple columns.
- Example for order by multiple columns.
- Live demo outputs
Syntax:
/* ORDER BY MULTIPLE COLUMNS */
SELECT *
FROM
YourTable
ORDER
BY YourCol1 DESC, YourCol1 ASC
Example for order by multiple columns
/* SQL SERVER ORDER BY MULTIPLE COLUMNS */
SELECT TOP 100 [UID]
,[ContactName]
,[LastUpdateBy]
FROM dbo.[User]
ORDER BY ContactName DESC, LastUpdateBy ASC
