MySQL - Sort by Multiple Columns in MySQL

Sort by Multiple Columns in MySQL

Q

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

✍: 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)

⇒SELECT Query Statements with GROUP BY in MySQL

⇒⇒MySQL Database Tutorials

2017-11-02, 586👍, 0💬

Count Number of Rows with SELECT Statements in MySQL
How To Use SELECT Statement to Count Number of Rows in MySQL? 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 fyi_links; +----------+ | COUNT(*) | +-------... 2018-01-06, 633👍, 0💬

Adding More Data to the Test Table in MySQL
How To Add More Data to the Testing Table in MySQL? 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_links ADD COLUMN tag VARCHAR(8); mysql&... 2017-11-02, 603👍, 0💬

Sorting Output in Descending Order in MySQL
How To Sort Output in Descending Order in MySQL? If you want to sort a column in descending order, you can specify the DESC keyword in the ORDER BY clause. The following SELECT statement first sorts the "tag" in descending order, then sorts the "counts" in ascending order: mysql> SELECT tag, ... 2017-11-02, 600👍, 0💬

Sort by Multiple Columns in MySQL
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_... 2017-11-02, 587👍, 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.