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