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.
Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:
Name | Dates | |
---|---|---|
Snowflake Training | Jan 21 to Feb 05 | View Details |
Snowflake Training | Jan 25 to Feb 09 | View Details |
Snowflake Training | Jan 28 to Feb 12 | View Details |
Snowflake Training | Feb 01 to Feb 16 | View Details |