MySQL SQL - Can the Query Output Be Sorted by Multiple Columns

Can the Query Output Be Sorted by Multiple Columns

Q

Can the Query Output Be Sorted by Multiple Columns? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY

✍: FYIcenter.com

A

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)

2007-05-11, 4392👍, 0💬

How To Sort the Query Output
How To Sort the Query Output? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY 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 ... 2007-05-11, 4675👍, 0💬

How To Use SELECT Statement to Count the Number of Rows
How To Use SELECT Statement to Count the Number of Rows? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following tutorial exercise shows you some good example: mysql> SELECT COUNT(*) FROM ... 2007-05-11, 4665👍, 0💬

How To Add More Data to the Testing Table
How To Add More Data to the Testing Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to continue with other tutorial exercises in this FAQ collection, you need to add more data to the testing table. Follow the script below to add a new column and : mysql> ALTER TABLE fyi_l... 2007-05-11, 4421👍, 0💬

Can the Query Output Be Sorted by Multiple Columns
Can the Query Output Be Sorted by Multiple Columns? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY 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 ... 2007-05-11, 4393👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.