Re: mac() from a subset

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,

Re: mac() from a subset

I have found the answer snip select max(greatest(f1,f2,f3 .)) from table /snip Sandy [EMAIL PROTECTED] a écrit dans le message de news: [EMAIL PROTECTED] 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

mac() from a subset

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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To