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 vote358 views1 answer
St_buffer mysql
SQL
6 votes341 views2 answers
Mysql set primary key
SQL
4 votes352 views1 answer
SQL find text in SP
SQL
15 votes360 views5 answers
If null mysql
SQL
6 votes348 views5 answers
Alter table oracle
SQL
0 vote376 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
32 votes443 views6 answers
Rename column mysql
SQL
0 vote356 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote319 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote322 views1 answer
Check sql query executed wp
SQL