Collections:
Sorting Query Output by Multiple Columns in SQL Server
Can the Query Output Be Sorted by Multiple Columns in SQL Server?
✍: FYIcenter.com
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
⇒ Sorting Query Output in Descending Order in SQL Server
⇐ Sorting Query Output with ORDER BY Clauses in SQL Server
⇑ Using SELECT Statements and GROUP BY Clauses in SQL Server
2016-10-26, 1485🔥, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...