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

3 votes356 views3 answers
Create table in microsoft sql server
SQL
0 vote348 views1 answer
UNION ALL LEFT JOIN
SQL
1 vote345 views1 answer
Oracle create as select
SQL
0 vote360 views1 answer
Createdb with postgresql on ubuntu
SQL
49 votes398 views6 answers
Alter table add column
SQL
0 vote362 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
1 vote346 views1 answer
How to drop function in sql
SQL
0 vote365 views1 answer
Regex any word except sql
SQL
5 votes374 views2 answers
Sql constraint check value in list
SQL
4 votes363 views2 answers
REST API
SQL