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

-1 vote313 views1 answer
MYSQL stored procedure select from
SQL
0 vote305 views3 answers
Convert sql query to python pandas
SQL
0 vote335 views1 answer
Limit in access query
SQL
44 votes368 views6 answers
Rename command in sql
SQL
0 vote294 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
4 votes316 views3 answers
Drop Table Oracle
SQL
2 votes294 views3 answers
Replace null in sql
SQL
0 vote326 views2 answers
Postgres show current role
SQL
0 vote306 views1 answer
Mysql_error replacement
SQL
0 vote323 views2 answers
Disadvantages of stored procedures sql
SQL