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

6 votes227 views1 answer
Sql insert values into table
SQL
0 vote249 views2 answers
Postgresql change user role grant
SQL
0 vote239 views1 answer
Oracle sql developer closed connection
SQL
1 vote357 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote258 views1 answer
Make parameters nullable in sql server
SQL
6 votes249 views2 answers
Sql sequence
SQL
1 vote241 views1 answer
Postgres convert date to string
SQL
0 vote233 views4 answers
Mysql select bottom 10 rows
SQL
1 vote199 views1 answer
Python escape string for sql
SQL
0 vote233 views1 answer
Rails sql query converstion
SQL