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 votes342 views3 answers
Start postgresql ubuntu
SQL
0 vote369 views1 answer
Sql date with year
SQL
1 vote335 views2 answers
Drop table if exists test
SQL
2 votes359 views1 answer
Use cases condition in sql query laravel
SQL
5 votes362 views4 answers
Start postgres server
SQL
1 vote336 views1 answer
Simple project for database
SQL
1 vote346 views1 answer
Declare table variable
SQL
2 votes371 views3 answers
Mysql pass command from command line
SQL
0 vote329 views1 answer
How to print out column name differently in mysql
SQL
0 vote346 views2 answers
Search stored procedures
SQL