HANA - Finding maximum in a row
I have a requirement to get the maximum value comparing multiple columns in a row. This has to be done in a HANA Stored Procedure code. The columns are around 10 so case statement is not feasible. Please suggest an alternate solution.
|Name||Date 1||Date 2||Date 3||Date 4||Date 5||Max Date|
In the 1st row 8th Jan is the max amongst the 5 date so its displayed , similarly for the 2nd row 8th Feb while for 3rd row 6th April gets displayed.
In your SQL manual have a look at keyword GREATEST.