How to specify the Sort order for a Query in SQL Server ?

AbundantCode 1 month ago in SQL Server 0

If you want the sort the records in descending order by more than one column instead of the default ascending order , you can use the DESC or DESCENDING to this.

How to specify the Sort order for a Query in SQL Server ?

Here’s the query which retrieves the Department records in Descending order by two columns – Name and GroupName.

Use AdventureWorks2014
GO
SELECT * from HumanResources.Department
ORDER BY Name DESC,
GroupName DESC
How to specify the Sort order for a Query in SQL Server ?
Tags : , , , 

Leave Your Comment