Sorting Query Output in Descending Order in SQL Server

Q

How To Sort Query Output in Descending Order in SQL Server?

✍: FYIcenter.com

A

If you want to sort a column in descending order, you can specify the DESC keyword in the ORDER BY clause. The following SELECT statement first sorts the "tag" in descending order, then sorts the "counts" in ascending order:

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

 

Using SELECT Statements and GROUP BY Clauses in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-26, 566👍, 0💬