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 vote182 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
11 votes184 views2 answers
Oracle saurce code
SQL
10 votes139 views2 answers
Mysql select timestamp group by day
SQL
7 votes208 views1 answer
Show line number in sql server
SQL
0 vote210 views1 answer
Ms sql print more than 1 variable
SQL
11 votes192 views1 answer
Oracle export view ddl
SQL
0 vote130 views1 answer
Flask_sqlalchemy install
SQL
0 vote202 views1 answer
How to insert same table data using mysql query
SQL
7 votes183 views3 answers
Foreign key oracle
SQL
0 vote181 views1 answer
Oracle query to find schema you are working on
SQL