Collections:
Sorting Output in Descending Order in MySQL
How To Sort Output in Descending Order in MySQL?
✍: FYIcenter.com
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, counts, url, DATE(created) FROM fyi_links ORDER BY tag DESC, counts; +------+--------+-------------------+---------------+ | tag | counts | url | DATE(created) | +------+--------+-------------------+---------------+ | SQA | 6 | sqa.fyicenter.com | 2006-07-01 | | SQA | 8 | www.winrunner.com | 2003-01-01 | | DEV | 4 | dev.fyicenter.com | 2006-04-30 | | DEV | 4 | www.php.net | 2004-01-01 | | DBA | 1 | www.mysql.com | 2006-01-01 | | DBA | 3 | dba.fyicenter.com | 2006-07-01 | | DBA | 7 | www.oracle.com | 2005-01-01 | +------+--------+-------------------+---------------+ 7 rows in set (0.01 sec)
⇒ Count Number of Rows with SELECT Statements in MySQL
⇐ Sort by Multiple Columns in MySQL
2017-11-02, 1438🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...