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

0 vote174 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
8 votes140 views2 answers
Update sql server from another table
SQL
0 vote146 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote144 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote141 views1 answer
Create table with primary key and foreign key in sql server
SQL
1 vote132 views1 answer
Select from one table where not on the other
SQL
0 vote144 views2 answers
Postgres another version
SQL
3 votes140 views1 answer
Select nextval from sequence sql
SQL
0 vote145 views1 answer
Calculate age in sql
SQL
1 vote144 views3 answers
Mysql Server Start
SQL