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 vote191 views2 answers
Sql stored procedure for access frontend
SQL
-1 vote258 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote148 views2 answers
Sql update from two different database
SQL
5 votes168 views6 answers
Sql add days to date
SQL
0 vote190 views1 answer
How to select a row in sql
SQL
0 vote169 views1 answer
Oracle INTERVAL DAY to second to number
SQL
6 votes173 views1 answer
What is where clause in sql
SQL
1 vote174 views1 answer
Create temporal table in sql
SQL
7 votes189 views5 answers
Sql remove spaces
SQL
1 vote177 views1 answer
Sql current timestamp
SQL