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

4 votes175 views5 answers
Primary key
SQL
0 vote204 views1 answer
Find wordpress version in database
SQL
1 vote164 views1 answer
Alphabetical order mysql
SQL
0 vote176 views1 answer
Sql query to get contact form 7 fields
SQL
1 vote128 views1 answer
Enable mysql slow query log
SQL
0 vote195 views1 answer
Ubuntu connect to mssql database
SQL
10 votes169 views3 answers
Insert into auto increment mysql
SQL
1 vote179 views1 answer
Sql select row with max date
SQL
0 vote161 views2 answers
Mysql create table if not exists
SQL
0 vote259 views1 answer
Sql if clause within where clause
SQL