Re: mac() from a subset

I have found the answer select max(greatest(f1,f2,f3 .)) from table "Sandy" <[EMAIL PROTECTED]> a écrit dans le message de news: [EMAIL PROTECTED] > Hi > > > select max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4 > from table > > > How can I extract a max value from t

Re: mac() from a subset

Sandy wrote: Hi select max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4 from table 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 max

mac() from a subset

Hi select max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4 from table 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 unsubscribe:ht