[thelist] SQL - ORDER with two parameters

Olavo Santos nbk at cyberdude.com
Wed Mar 31 14:22:30 CST 2004


From: "Adriano Castro" <ad at netvisao.pt>
Sent: Tuesday, March 30, 2004 5:19 PM

    Hello.

>     How can I do this using a simple SQL query?

    If you use MySQL you probably could use subqueries:

    For version 4.1:


http://www.mysql.com/documentation/mysql/bychapter/manual_SQL_Syntax.html#Subqueries

    For earlier versions (like 4.0):


http://www.mysql.com/documentation/mysql/bychapter/manual_SQL_Syntax.html#Rewriting_subqueries

Best regards,

@778, Nbk

P.s. - Lols. http://temp.adrianocastro.net/archives/000157.html :-)



More information about the thelist mailing list