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

33 votes131 views6 answers
Sql delete
SQL
0 vote114 views1 answer
Import sql mysql ubuntu
SQL
2 votes124 views2 answers
Mysql user access to database
SQL
1 vote130 views1 answer
Oracle case
SQL
-1 vote116 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote163 views1 answer
Tsql cte in a transaction
SQL
6 votes161 views2 answers
Oracle compile trigger
SQL
0 vote148 views2 answers
PostgreSQL having
SQL
0 vote147 views1 answer
Postgres get database encoding
SQL
0 vote195 views1 answer
Mysql update table from select on another table
SQL