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

Rishi Raj

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

• Related Questions & Answers
• Different SAP HANA Administration tools
• Different Aggregation functions in SAP HANA
• Different perspectives in SAP HANA Studio
• Different Engine types in SAP HANA
• Different Package type in SAP HANA
• Different License types in SAP HANA
• Different Engine types in SAP HANA Architecture
• Using different Engine types in SAP HANA
• Different Audit trial targets in SAP HANA
• Different authentication methods supported in SAP HANA
• Different table symbol in SAP HANA database
• Different schema types in SAP HANA database
• Finding a database view in SAP HANA database
• Finding index of rows and columns in SAP
• Different options in Data Preview in SAP HANA