Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have data as below. I want to add new column with the max data for each row. How can I do this:
DOC | D1 | D2 | D3 | D4 |
FA_1 | 2014-12-15 | 2014-11-30 | 2014-12-07 | 2014-11-29 |
FA_2 | 2014-12-05 | 2014-12-13 | 2014-12-04 | |
FA_3 | 2014-12-25 | 2014-12-24 | 2014-12-26 |
RangeMax(D1,D2,D3,D4) as MaxD
RangeMax(D1,D2,D3,D4) as MaxD