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

28 votes123 views4 answers
Delete database mysql
SQL
0 vote131 views1 answer
Oracle sql add column auto generated value
SQL
0 vote131 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
3 votes124 views1 answer
Stpop start psql server
SQL
0 vote115 views3 answers
Joins and views sql
SQL
0 vote128 views2 answers
Sql query in dax power bi
SQL
0 vote125 views1 answer
MySql get primary keys of table
SQL
0 vote128 views1 answer
Update one column from another column in same table
SQL
2 votes160 views1 answer
Oracle log files
SQL
7 votes119 views3 answers
How to check table name in current database sql
SQL