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
Published on 14-Dec-2017 05:17:25
Advertisements