Re: How can I do something like this "SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3);" ?

[Ricardas S]

Have you tried
MAX((col1*(MAX_VALUE_OF_COL1+1)+col2)*(MAX_VALUE_OF_COL2+1)+col3)
----- Original Message ----- 
From: "KLEIN Stéphane" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, June 13, 2007 09:30
Subject: How can I do something like this "SELECT MAX(col1, col2, col3) FROM mytable 
ORDER BY MAX(col1, col2, col3);" ?


Hi,

I would like do something like :

SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3);

I know this syntax is wrong but I would like get a solution to this stuff.

Thanks for your help.
Stephane

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]