Sandy wrote:
Hi
<code snippet>
select max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4 from
table
</code>
How can I extract a max value from the 4 columns of the result ?
ex: greatest(nf1,nf2,nf3,nf4)
Thanks
SELECT MAX (max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as
nf4) AS maximum FROM table
Not tested but should work :)
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]