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 vote458 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
4 votes364 views1 answer
Add constraint fk
SQL
0 vote360 views1 answer
Tsql generate rows
SQL
0 vote365 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote400 views1 answer
Cahnge column name apex oracle
SQL
1 vote355 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote438 views1 answer
Mysql convert charset
SQL
3 votes355 views2 answers
Oracle apex view logs
SQL
0 vote385 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote345 views1 answer
Mariadb maximum left join
SQL