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 vote90 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote130 views2 answers
How to update date in oracle
SQL
0 vote129 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote194 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
0 vote136 views2 answers
Sql auto update dupdated_at
SQL
5 votes159 views1 answer
Migrate sql table another database
SQL
0 vote159 views1 answer
Oracle date summer time
SQL
2 votes140 views1 answer
Node and mysql like
SQL
0 vote125 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote122 views1 answer
Change default schema sql server
SQL