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 vote172 views1 answer
If exist column in table drop sql query mysql
SQL
34 votes168 views6 answers
Install mysql client ubuntu
SQL
0 vote167 views1 answer
User defined variables in sql
SQL
0 vote169 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote225 views1 answer
Delete from IN subquery
SQL
0 vote229 views1 answer
Osm2pgsql mac
SQL
1 vote167 views1 answer
Get table which have specific columns in mysql
SQL
1 vote173 views2 answers
Regex starts with
SQL
1 vote168 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote162 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL