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

24 votes241 views4 answers
Delete db postgres
SQL
0 vote196 views1 answer
Mysql date minus 1 day
SQL
28 votes205 views6 answers
Sql update
SQL
0 vote249 views1 answer
Sql character index
SQL
26 votes210 views2 answers
Mysql workbench download
SQL
0 vote224 views1 answer
Postegresql update to null
SQL
5 votes206 views2 answers
Oracle timestamp to date
SQL
79 votes589 views6 answers
Grepper code
SQL
0 vote207 views1 answer
Group by join columns per table
SQL
0 vote232 views1 answer
Sql file in postgres with pgadmin
SQL