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 | Nov 01 to Nov 16 | View Details |
| Snowflake Training | Nov 04 to Nov 19 | View Details |
| Snowflake Training | Nov 08 to Nov 23 | View Details |
| Snowflake Training | Nov 11 to Nov 26 | View Details |