I have table with columns like this:
| Column A | Column B | Column C | Column D | Column E |
|---|---|---|---|---|
| 15 | 12 | 43 | 15 | |
| 21 | 24 | 12 | 3 | |
| 8 | 4 | 62 | 25 | |
| NULL | 87 | 25 | 37 |
I want is maximum of each row in Column E.
I tried GREATEST() function in SSMS 19.0 but it’s gives “‘Greatest’ is not a recognized built-in function name” as error. Is there any other ways to find the maximum of each row and to insert in Column5 and what if insert columns dynamically is there any way for that also?