Syntax error Finding minimum value across different columns in SAP HANA

Finding minimum value across different columns in SAP HANA



You need to use LEAST instead of min as below:

“SELECT ID, LEAST(DAY_1, DAY_2, DAY_3) FROM ...”

 Please make sure that none of the values in your column in “NULL”.

Updated on: 2019-12-05T09:20:19+05:30

643 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements