Snowflake Supports GREATEST/LEAST_IGNORE_NULLS
Mar 28, 2024
At Snowflake, we are committed to continuously enhancing our platform with new functions for a better developer experience. In response to a common request from our community, we have added two new functions: GREATEST_IGNORE_NULLS and LEAST_IGNORE_NULLS. These functions will return the greatest and least non-null values from the list of arguments, so that you don’t need to wrap your arguments with NVL/COALESCE anymore. For more information, please visit our documentation.