Finding minimum value across different columns in SAP HANA

SAP HANASAPSAP Basis

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”.

raja
Updated on 05-Dec-2019 09:20:19

Advertisements