⟩ Can the Query Output Be Sorted by Multiple Columns in MS SQL Server?
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 ggl_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 rendc.org 2007-05-19
DEV 120 rendc.org/xml 2006-04-30
DEV 439 www.php.net 2004-01-01
SQA 728 rendc.org/sql 2007-05-19
SQA 828 www.winrunner.com 2003-01-01
