SQL Server - Sorting Query Output with ORDER BY Clauses in SQL Server

Sorting Query Output with ORDER BY Clauses in SQL Server

Q

How To Sort the Query Output with ORDER BY Clauses in SQL Server?

✍: FYIcenter.com

A

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 by the values in the "counts" column:

SELECT * FROM fyi_links ORDER BY counts
GO
id   url                notes  counts  created     tag
101  dev.fyicenter.com  NULL   120     2006-04-30  DEV
104  www.mysql.com             390     2006-01-01  DBA
106  www.php.net               439     2004-01-01  DEV
103  sqa.fyicenter.com  NULL   728     2007-05-19  SQA
107  www.winrunner.com         828     2003-01-01  SQA
105  www.oracle.com            960     2005-01-01  DBA
102  dba.fyicenter.com  NULL   972     2007-05-19  DBA

The output is sorted by the values of the "counts" column.

⇒Using SELECT Statements and GROUP BY Clauses in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-26, 573👍, 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, 566👍, 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, 530👍, 0💬

Selecting Some Specific Rows from a Table in SQL Server
How To Select Some Specific Rows from a Table in SQL Server? If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The WHERE clause condition is a normal Boolean expression. If an... 2016-10-26, 487👍, 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.