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, 1550🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...