[EMAIL PROTECTED] wrote:
Hi all,
what is max ? it's the first row when we sort data in descending order.
so
select col1,col2,col3,col4 ... from table
order by concat(col1,col2,col3,col4 ... ) desc
LIMIt 1;
should be silar to what is needed. I say should :o)
That would only work if the greatest values for col2, col3, col4, etc., all
occurred in the same row with the greatest value for col1, and if all the values
for col1 had the same number of digits (and the same for col2, col3, etc.).
Consider this table:
10 2 3
5 4 8
1 12 7
Your query would give 5, 4, 8 (because "548" as a string is greater than "1023"
or "1127"), but he wants 10, 12, 8.
--
Keith Ivey <[EMAIL PROTECTED]>
Smokefree DC
http://www.smokefreedc.org
Washington, DC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
