PDA

View Full Version : max at the same time of 3 fields



insea
02-15-2008, 05:46 PM
Hi people,

I have 3 fields in one table and i would like to have at the some time the max of this fields. Can you help me?
Regards

insea

stanl
02-16-2008, 08:23 AM
just a guess, but are you looking at something like


SELECT MAX(f1)+MAX(f2)+MAX(f3) as MaxSum FROM [sometable]...


where I think you need to account for Null values etc....

insea
02-16-2008, 05:21 PM
That's exactly what i need.
Thanks a lot.
Regards

insea