Sorting Query Output in Descending Order in SQL Server


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



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
tab     counts  url                     created
SQA     728       2007-05-19
SQA     828       2003-01-01
DEV     120       2006-04-30
DEV     439             2004-01-01
DBA     390           2006-01-01
DBA     960          2005-01-01
DBA     972       2007-05-19


Counting Rows with the COUNT(*) Function in SQL Server

Sorting Query Output by Multiple Columns in SQL Server

Using SELECT Statements and GROUP BY Clauses in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-10-26, 1490🔥, 0💬