Count with where

Condition in count sql

select count(case Position when 'Manager' then 1 else null end)
from ...


select sum(case Position when 'Manager' then 1 else 0 end)
from ...

Count with where

select count(case Position when 'Manager' then 1 else null end)
from ...

Source: stackoverflow.com

Count with where

SELECT 
    DATE,
    COUNT(DISTINCT CASE WHEN TYPE = 'Existing' THEN ID END) AS "EXISTING",
    COUNT(DISTINCT CASE WHEN TYPE = 'New' THEN ID END) AS "NEW"
FROM 
    mytab
WHERE 
    DATE >= '2022-01-01'
GROUP BY    
    DATE ;

Source: niceans.com

Similar codes

21 votes256 views3 answers
Average sql
SQL
0 vote252 views1 answer
The local psql command could not be located
SQL
2 votes266 views1 answer
Oracle current date without time
SQL
3 votes292 views3 answers
Raw select laravel
SQL
23 votes245 views6 answers
Create table sql
SQL
0 vote227 views1 answer
Delete all rows from table sqlite
SQL
0 vote269 views1 answer
Sql query to get column names and data types in sql server
SQL
1 vote265 views2 answers
How to add amount between date in sql
SQL
1 vote270 views2 answers
Remove space in mysql
SQL
1 vote262 views1 answer
Sql where last 12 months
SQL