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 vote100 views1 answer
Inserting data into different tables at once in oracle sql
SQL
1 vote106 views1 answer
Drop function
SQL
0 vote111 views1 answer
Foreign key multiple columns
SQL
0 vote103 views1 answer
Mysql default timestamp value to be current timestamp
SQL
1 vote103 views1 answer
Type int in mysql maxlenght
SQL
0 vote115 views1 answer
Select new table sql
SQL
2 votes104 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote115 views1 answer
Mysql update set sum
SQL
1 vote140 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote94 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL