>>For each record, I need to retrieve the maximum of 3 columns.
>>
>>Example:
>>ID 1 has column C1= 2, C2=5, C3=1
>>ID 2 has column C1=6, C2=3, C3=8
>>
>>I need maximum of C1,C2,C3:
>>ID 1 gives 5
>>ID 2 gives 8
>>
>>Can we do this using SELECT statement?
>>Thank you all!
>
>
>select field1, field2, max(c1, c2, c3) as mymax from table1
>
>
>HTH,
Strange, but this one gave me an error, while my SQL doesn't. I wrote it, then saw your response, then decided to test... :)
If it's not broken, fix it until it is.
My Blog