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, 5059👍, 0💬
Popular Posts:
What will be printed as the result of the operation below: main() { char s1[]="Cisco"; char s2[]="sy...
How To Increment Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
What does AddressOf operator do in background ? The AddressOf operator creates a delegate object to ...
What's the output of the following program? And why? #include main() { typedef union { int a; char b...
what is a service contract, operation contract and Data Contract? - part 1 In the below sample we ha...