SQL Server - Sorting Query Output by Multiple Columns in SQL Server

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, 706👍, 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, 707👍, 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, 696👍, 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, 690👍, 0💬

Adding More Test Data for Query Statements in SQL Server
How To Add More Data to the Testing Table in SQL Server? If you want to continue with other tutorial exercises in this FAQ collection, you need to add more data to the testing table. Follow the script below to add a new column and more rows: ALTER TABLE fyi_links ADD tag VARCHAR(8) GO UPDATE fyi_lin... 2016-10-26, 639👍, 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.