Is is poslbe too get the highest value from a row?
IE. I have 3 days as columns with a timestamp value, can i get the highest value out?
I tested this and it doesn't work. Furthermore the MySQL docs on MAX() make no mention of comma delimited list functionality -- http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_max
Asaph
2010-02-08 15:50:48
`MAX` is an aggregate in MySQL (http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html) - that syntax works on SQLite, not MySQL.
OMG Ponies
2010-02-08 15:51:28
+3
A:
GREATEST() might be what you want:
http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html#function_greatest
dbemerlin
2010-02-08 15:49:22