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 vote232 views1 answer
Sql count how many times a value appears
SQL
1 vote281 views1 answer
Sqlite check if row exists
SQL
2 votes282 views1 answer
Import large .sql files into lampp
SQL
2 votes291 views1 answer
Sql server check for value in multiple columns
SQL
1 vote310 views1 answer
Login to database mysql terminal
SQL
3 votes358 views1 answer
Apex call duration
SQL
0 vote387 views2 answers
Sqlalchemy default value for column
SQL
3 votes469 views6 answers
Sql unique select
SQL
0 vote301 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote294 views2 answers
Mysql row_number() example
SQL