Get the max field value from each row

Question

How Can I get the max value from few columns for each table row?

ID          Date1      Date2      
----------- ---------- ---------- 
1           2019-01-01 2019-12-29

result:

ID          MaxDate   
----------- ---------- 
1           2019-12-29

How is `'Avraham'` "greater than" `'Yaakov'`? `'Avraham'` has the lowest value of those names, not the greatest. — Thom A, Dec 25 '19 at 10:15
@Michal for the names you only compare with the first letter ? — Amira Bedhiafi, Dec 25 '19 at 10:18

Amira Bedhiafi · Answer 1 · 2019-12-25T10:22:44.253

0

MS SQL Server 2017 Schema Setup:

CREATE TABLE MyTable (ID int,Date1 date,Date2 date)
INSERT INTO MyTable (ID,Date1,Date2) VALUES ('1','2019-01-01','2019-12-29')

Query 1:

SELECT
    ID,CASE
        WHEN Date1 >= Date2   THEN Date1
        WHEN Date2 >= Date1 THEN Date2
ELSE   Date1
    END AS MaxDate

    FROM MyTable

| ID |    MaxDate |
|----|------------|
|  1 | 2019-12-29 |

edited Dec 25 '19 at 10:22

answered Dec 25 '19 at 10:15

Amira Bedhiafi

Michal · Answer 2 · 2019-12-25T10:21:00.553

0

select ID,(select max(d) from (select Date1 d uninon select Date2 d) as t) as MaxDate
from MyTable

edited Dec 25 '19 at 10:21

answered Dec 25 '19 at 10:15

Michal

5

While this answer may be correct. Code only answers are rarely helpful. Please comment your code and provide an explanation for how this code solves the problem. – RyanNerd Dec 25 '19 at 11:50

2 Answers2