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 vote196 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote209 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote175 views1 answer
Automate mysql cli query
SQL
0 vote185 views1 answer
Show function mysql
SQL
0 vote148 views1 answer
Como leer datos de mysql esp32
SQL
7 votes222 views3 answers
Sql server check if temp table exists
SQL
4 votes176 views3 answers
Sql find second highest salary employee
SQL
0 vote185 views1 answer
Char varchar nvarchar sql
SQL
0 vote228 views1 answer
Sql server datetime
SQL
0 vote208 views1 answer
Load data infile mariadb slow
SQL