Collections:
Sorting Query Output with ORDER BY Clauses in SQL Server
How To Sort the Query Output with ORDER BY Clauses in SQL Server?
✍: FYIcenter.com
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.
⇒ Sorting Query Output by Multiple Columns in SQL Server
⇐ Adding More Test Data for Query Statements in SQL Server
⇑ Using SELECT Statements and GROUP BY Clauses in SQL Server
2016-10-26, 1449🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...