Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Sort the Query Output
How To Sort the Query Output? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY
✍: 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)
2007-05-11, 5147👍, 0💬
Popular Posts:
Can you explain the fundamentals of “GetGlobalResourceObject ”and “GetLocalResourceObject” function...
What Happens If One Row Has Missing Columns? - XHTML 1.0 Tutorials - Understanding Tables and Table ...
What Is Posting? Posting is an event that writes Inserts, Updates and Deletes in the forms to the da...
What Is the Data Pump Import Utility? - Oracle DBA FAQ - Loading and Exporting Data Oracle Data Pump...
Can you explain steps in function points? Below are the steps in function points: >First Count ILF, ...