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

6 votes89 views3 answers
Can you update NULL in sql
SQL
0 vote120 views1 answer
How to change mysql root password in windows 10
SQL
4 votes104 views1 answer
SQL order random
SQL
0 vote105 views1 answer
Mysql where in keep order
SQL
0 vote104 views1 answer
Mysql uuid
SQL
0 vote104 views2 answers
Drop check constraint in ms sql
SQL
0 vote119 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote106 views2 answers
Sqlite unique
SQL
25 votes110 views6 answers
Sql update query
SQL
1 vote113 views1 answer
What is a Database?
SQL