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 vote276 views2 answers
Fanyi
SQL
9 votes251 views3 answers
Postgres make sql dump
SQL
0 vote226 views1 answer
Mysql grant user wildcard database
SQL
22 votes214 views2 answers
Mysql show all tables
SQL
0 vote276 views1 answer
Osm2pgsql mac
SQL
0 vote228 views2 answers
Python mysql create table if not exists
SQL
3 votes215 views1 answer
Postgres update column with value from another table
SQL
0 vote225 views1 answer
Sql server insert inner join
SQL
0 vote228 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
3 votes245 views2 answers
Oracle drop sequence
SQL