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 vote149 views1 answer
Foreign key multiple columns
SQL
2 votes122 views1 answer
Codeigniter print last sql query
SQL
0 vote128 views1 answer
Create table employees oracle
SQL
11 votes151 views5 answers
Sql server reset identity
SQL
2 votes181 views1 answer
Sql compare strings
SQL
1 vote141 views1 answer
Sql server list locks
SQL
0 vote165 views1 answer
Create table with timestamp mysql youtube
SQL
1 vote141 views1 answer
Where not in array sql
SQL
1 vote144 views1 answer
Postgresql create table with timestamp
SQL
0 vote138 views1 answer
Compare subqueries oracle
SQL