If we try to apply the ISNULL function in Snowflake, it will not work: SET val=NULL; SELECT ISNULL($val, 0) as VAL; As we can see, we received an error message clearly mentioning that ISNULL is an unknown function. In Snowflake, instead of the ISNULL, the IFNULL function can b...
Learn-SQL / PostgreSQL / How to Use nullif() in PostgreSQL Thenullif()function returns a null value, if a the value of the field/column defined by the first parameter equals that of the second. Otherwise, it will return the original value. Here's an example below: ...