How to Compare Two Values When One Value is Null in Snowflake

Snowflake - Compare two Values When One Value is Null

When we want to compare two snowflake columns and determine how many columns are distinct:

select count(2)
from sessions1
where start_date1  != end_date1;

If some start or end dates are null, they are not counted. To avoid this problem, we have to utilise the “INTERSECT” operator:

‘select count(2)
from sessions1
where not exists(select start_date1 from sessions1 intersect select end_date1 from sessions1);

Now, our count is “null aware” and we will get the result we require.   

Conclusion

This blog helps you handle the null columns while comparing the Snowflake columns. I hope this information is adequate for managing the null columns.

Snowflake Related Articles

▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop

▶  Snowflake Time Travel

If you have any queries, let us know by commenting below.