To perform multiple counts, we can merge the “sum()” function with the “CASE” statement. This article teaches you combining the “CASE” statement and the “SUM” function.
In Snowflake, for doing multiple counts in a single query, we have to combine “sum()” with “CASE Statement:”
select
count(1),
sum(case when name = ‘Table1’ then one else 0 end),
sum(case when category = 4, then one else 0 end),
from products1
By merging the “CASE” statement and “sum()” function, we can get multiple counts in one query. I hope this is adequate for fetching multiple counts in Snowflake.
Snowflake Related Articles
If you have any queries, let us know by commenting below.
Name | Dates | |
---|---|---|
Snowflake Training | Sep 17 to Oct 02 | View Details |
Snowflake Training | Sep 21 to Oct 06 | View Details |
Snowflake Training | Sep 24 to Oct 09 | View Details |
Snowflake Training | Sep 28 to Oct 13 | View Details |
Kalla Saikumar is a technology expert and is currently working as a Marketing Analyst at MindMajix. Write articles on multiple platforms such as Tableau, PowerBi, Business Analysis, SQL Server, MySQL, Oracle, and other courses. And you can join him on LinkedIn and Twitter.