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

-2 votes264 views1 answer
How to open database
SQL
0 vote301 views1 answer
Mysql sum per week
SQL
2 votes275 views1 answer
Postgresql drop primary key constraint
SQL
1 vote269 views1 answer
Adding a default constraint to an existing column in sql
SQL
1 vote286 views2 answers
Mysql between
SQL
0 vote282 views2 answers
How to generate a unique random number in mysql
SQL
0 vote278 views2 answers
How to delete the rows with null values in mysql
SQL
6 votes287 views2 answers
Mysql interval 1 day
SQL
3 votes269 views2 answers
Coalesce mysql
SQL
0 vote295 views1 answer
Create a sql server database programmatically
SQL