Sorting the Data in a Query in SQL Server

Published on August 20, 2016 by abundantcode

Filed under SQL Server

Last modified August 20, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 313 times

You want the results of the query to be displayed in a sorted order based on some query. In this case , you use the ORDER BY clause in the query by specifying the column on which the sort to work.

For example , you want to sort the Departments table in the database by the column DepartmentName. Here’s how the query looks like

Use AdventureWorks2014
SELECT * from HumanResources.Department

This query would return the departments sorted in ASCENDING ORDER by default on the column “Name”.


If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment