- Explore
- Collaborate
- Visualize
- Connect
- Pricing
How to Have Multiple Counts in SQL Server
To do multiple counts in one query in SQL Server, 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 = 5 then 1 else 0 end) -- count all category 5 products
from products;
From SQL Server query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and SQL Server
From SQL Server query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and SQL Server