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 | Jul 27 to Aug 11 | View Details |
Snowflake Training | Jul 30 to Aug 14 | View Details |
Snowflake Training | Aug 03 to Aug 18 | View Details |
Snowflake Training | Aug 06 to Aug 21 | 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.