Can the Query Output Be Sorted by Multiple Columns in MySQL?

You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns employees' salaries sorted by department and salary value:

mysql> SELECT tag, counts, url, DATE(created) 
   FROM fyi_links ORDER BY tag, counts;
+------+--------+-------------------+---------------+
| tag  | counts | url               | DATE(created) |
+------+--------+-------------------+---------------+
| DBA  |      1 | www.mysql.com     | 2006-01-01    |
| DBA  |      3 | dba.fyicenter.com | 2006-07-01    |
| DBA  |      7 | www.oracle.com    | 2005-01-01    |
| DEV  |      4 | dev.fyicenter.com | 2006-04-30    |
| DEV  |      4 | www.php.net       | 2004-01-01    |
| SQA  |      6 | sqa.fyicenter.com | 2006-07-01    |
| SQA  |      8 | www.winrunner.com | 2003-01-01    |
+------+--------+-------------------+---------------+
7 rows in set (0.00 sec)

⇒SELECT Query Statements with GROUP BY in MySQL

⇒⇒MySQL Database Tutorials