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

378 Views

Kickstart Your Career

Get certified by completing the course

Get Started