Home Forums SQL Server 2005 Administering select query RE: select query
Zidar
SSChasing Mays
Points: 651
More actions
December 4, 2013 at 11:13 am
#1670804
This should do the trick:
SELECT CASE WHEN Field1 >= Field2 THEN CASE WHEN Field1 >= Field3 THEN Field1 ELSE Field3 END ELSE CASE WHEN Field2 >= Field3 THEN Field2 ELSE Field3 END END AS MaxOf3FieldsFROM MyTable
SELECT
CASE
WHEN Field1 >= Field2 THEN
CASE WHEN Field1 >= Field3 THEN Field1 ELSE Field3 END
ELSE
CASE WHEN Field2 >= Field3 THEN Field2 ELSE Field3 END
END AS MaxOf3Fields
FROM MyTable
🙂