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.
2016-10-26, 689👍, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
Where to find answers to frequently asked questions on Oracle Database 10g Express Edition? I want t...
What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Rela...
How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...