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 vote294 views1 answer
Sql server datetime to string
SQL
0 vote285 views1 answer
Replace multiple string in query sql
SQL
25 votes294 views4 answers
Metadata
SQL
5 votes275 views6 answers
Sql add days to date
SQL
0 vote285 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote290 views1 answer
Mysql change timestamp on update
SQL
0 vote309 views1 answer
How to find the most occuring in SQL
SQL
1 vote305 views1 answer
How to test for sql injection
SQL
2 votes288 views1 answer
Merge two columns in sql oracle
SQL
6 votes306 views2 answers
Psql load dump
SQL