Sorting Query Output by Multiple Columns in SQL Server

Q

Can the Query Output Be Sorted by Multiple Columns in SQL Server?

✍: FYIcenter.com

A

You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns rows sorted by "tag" and "counts" values:

SELECT tag, counts, url, created 
   FROM fyi_links ORDER BY tag, counts
GO
tab     counts  url                     created
DBA     390     www.mysql.com           2006-01-01
DBA     960     www.oracle.com          2005-01-01
DBA     972     dba.fyicenter.com       2007-05-19
DEV     120     dev.fyicenter.com       2006-04-30
DEV     439     www.php.net             2004-01-01
SQA     728     sqa.fyicenter.com       2007-05-19
SQA     828     www.winrunner.com       2003-01-01

 

Using SELECT Statements and GROUP BY Clauses in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-26, 589👍, 0💬