Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
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, 4996👍, 0💬
Popular Posts:
Does .NET support UNICODE and how do you know it supports? Yes .NET definitely supports UNICODE. Try...
How can I check for HTML errors? HTML validators check HTML documents against a formal definition of...
What Happens If a Hyper Link Points to a Music File? - XHTML 1.0 Tutorials - Understanding Hyper Lin...
Can you write a program to interchange 2 variables without using the third one? a = 7; b = 2; a = a ...
when should the volatile modifier be used? The volatile modifier is a directive to the compiler's op...