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 votes388 views1 answer
Sql find not in list
SQL
51 votes438 views6 answers
Change column name sql
SQL
0 vote336 views1 answer
Oracle archivelog usage
SQL
0 vote322 views2 answers
Sql update top 100
SQL
0 vote324 views1 answer
Drop column from table if exist on live server mysql
SQL
1 vote308 views3 answers
Default password of mysql
SQL
1 vote372 views1 answer
Concat first name and last name in mysql
SQL
0 vote357 views1 answer
Updating database in sql
SQL
0 vote399 views1 answer
ALV GRID events
SQL
1 vote371 views1 answer
Sql insert for each distinct value
SQL