Collections:
Sorting Query Output in MySQL
How To Sort the Query Output in MySQL?
✍: FYIcenter.com
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 returns rows sorted by the values in the "counts" column:
mysql> SELECT id, url, counts, DATE(created), tag FROM fyi_links ORDER BY counts; +-----+-------------------+--------+---------------+------+ | id | url | counts | DATE(created) | tag | +-----+-------------------+--------+---------------+------+ | 104 | www.mysql.com | 1 | 2006-01-01 | DBA | | 102 | dba.fyicenter.com | 3 | 2006-07-01 | DBA | | 101 | dev.fyicenter.com | 4 | 2006-04-30 | DEV | | 106 | www.php.net | 4 | 2004-01-01 | DEV | | 103 | sqa.fyicenter.com | 6 | 2006-07-01 | SQA | | 105 | www.oracle.com | 7 | 2005-01-01 | DBA | | 107 | www.winrunner.com | 8 | 2003-01-01 | SQA | +-----+-------------------+--------+---------------+------+ 7 rows in set (0.07 sec)
⇒ Sort by Multiple Columns in MySQL
⇐ Adding More Data to the Test Table in MySQL
2017-11-02, 1555🔥, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...