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

0 vote282 views1 answer
View psql output in horizontal scrolling
SQL
14 votes288 views6 answers
Auto_increment mysql
SQL
1 vote270 views1 answer
Postgres start database on linux
SQL
1 vote263 views2 answers
Rebuild index sql server
SQL
1 vote313 views2 answers
This month mysql where
SQL
1 vote265 views1 answer
Sql select contem uma palavra
SQL
0 vote267 views1 answer
Use where instead of join
SQL
0 vote308 views1 answer
Typical max-connect-errors mysql
SQL
0 vote291 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote285 views1 answer
Plpgsql raise notice
SQL