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
2016-10-26, 706👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Tr...
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic...
Where to find answers to frequently asked questions on Oracle Database 10g Express Edition? I want t...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...