Collections:
Sort by Multiple Columns in MySQL
Can the Query Output Be Sorted by Multiple Columns in MySQL?
✍: FYIcenter.com
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)
⇒ Sorting Output in Descending Order in MySQL
⇐ Sorting Query Output in MySQL
2017-11-02, 1321🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...