Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

SQL MAX of multiple columns?

ayi

<t>SQL MAX of multiple columns?</t>

ayi

<t>This is an old answer and broken in many way. 
 
See https://stackoverflow.com/a/6871572/194653 which has way more upvotes and works with SQL Server 2008+ and handles nulls, etc. 
 
Original but problematic answer: 
 
Well, you can use the CASE expression:

SELECT<br/>
    CASE<br/>
        WHEN Date1 >= Date2 AND Date1 >= Date3 THEN Date1<br/>
        WHEN Date2 >= Date1 AND Date2 >= Date3 THEN Date2<br/>
        WHEN Date3 >= Date1 AND Date3 >= Date2 THEN Date3<br/>
        ELSE                                        Date1<br/>
    END AS MostRecentDate<br/>
<br/>
```</t>