📘Introducing SQL Notebooks: Tell stories using data.Read more →

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:

  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

Ready for a modern SQL editor?