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

6 votes313 views1 answer
Update left join mysql
SQL
0 vote307 views1 answer
What is logical database schema
SQL
0 vote411 views1 answer
Current month transactions in mysql
SQL
0 vote318 views1 answer
Mysql insert into select with recursive
SQL
1 vote322 views2 answers
Sql select only row with the max date
SQL
0 vote324 views1 answer
How to check the port of mysql installation in mac
SQL
2 votes370 views2 answers
Create temporary table in mysql
SQL
1 vote279 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote318 views1 answer
Fetch second word from a string in ms sql
SQL
1 vote271 views1 answer
Unique vs distinct sql
SQL