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, 1388🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...