MS SQL Server Concepts and Programming Question: Download Questions PDF
How To Sort Query Output in Descending Order in MS SQL Server?
Answer:
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 ggl_links ORDER BY tag DESC, counts
GO
<pre>
tab counts url created
SQA 728 globalguideline.com/sql 2007-05-19
SQA 828 www.winrunner.com 2003-01-01
DEV 120 globalguideline.com/xml 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 globalguideline.com 2007-05-19
</pre>
SELECT tag, counts, url, created
FROM ggl_links ORDER BY tag DESC, counts
GO
<pre>
tab counts url created
SQA 728 globalguideline.com/sql 2007-05-19
SQA 828 www.winrunner.com 2003-01-01
DEV 120 globalguideline.com/xml 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 globalguideline.com 2007-05-19
</pre>
Download MS SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can the Query Output Be Sorted by Multiple Columns in MS SQL Server? | How To Count Rows with the COUNT(*) Function in MS SQL Server? |