SQL Server - Sorting Query Output in Descending Order in SQL Server

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💬

Using SELECT Statements on Views in SQL Server
Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: CREATE VIEW myLinks AS SELECT * FROM fyi_links WHERE url LIKE '%fyi%' G... 2016-10-26, 1030👍, 0💬

Sorting Query Output by Multiple Columns in SQL Server
Can the Query Output Be Sorted by Multiple Columns in SQL Server? 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 ta... 2016-10-26, 590👍, 0💬

Sorting Query Output with ORDER BY Clauses in SQL Server
How To Sort the Query Output with ORDER BY Clauses in SQL Server? If you want the returning rows to be sorted, you can specify a sorting expression in the ORDER BY clause. The simplest sort expression is column name who's values will be sorted by. The following select statement returns rows sorted b... 2016-10-26, 574👍, 0💬

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, cou... 2016-10-26, 567👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.