How to Have Multiple Counts in Snowflake in Snowflake

To do multiple counts in one query in Snowflake, you can combine sum() with the CASE statement:

select
  count(1), -- count all products
  sum(case when name = 'Table' then 1 else 0 end), -- count all tables
  sum(case when category = 4 then 1 else 0 end) -- count all category 4 products
from products

Previous

Next

Ready for a modern SQL editor?