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 vote150 views1 answer
Sql server roles and users
SQL
0 vote133 views1 answer
Connecting to my cloud sql server with c#
SQL
3 votes142 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote179 views1 answer
Sql count matching group by
SQL
2 votes186 views3 answers
3 days back in sql server
SQL
0 vote145 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote145 views1 answer
Sqlite higher or equal
SQL
11 votes142 views2 answers
Oracle source code
SQL
1 vote142 views1 answer
DATE_SUB postgres
SQL
0 vote137 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL