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.
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
If you have any queries, let us know by commenting below.
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Name | Dates | |
---|---|---|
Snowflake Training | Sep 26 to Oct 11 | View Details |
Snowflake Training | Sep 30 to Oct 15 | View Details |
Snowflake Training | Oct 03 to Oct 18 | View Details |
Snowflake Training | Oct 07 to Oct 22 | View Details |
1 / 10
Copyright © 2013 - 2023 MindMajix Technologies