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

1 vote254 views1 answer
Rename table column name in mysql
SQL
3 votes265 views3 answers
Start postgresql ubuntu
SQL
0 vote280 views1 answer
Postgres dump sql insert
SQL
0 vote247 views1 answer
Json not contains mysql
SQL
0 vote215 views1 answer
Kannst du deine finger trainieren
SQL
1 vote262 views3 answers
Date_add mysql
SQL
9 votes284 views3 answers
Pyodbc connect to sql server
SQL
0 vote253 views1 answer
Postgres reorder columns
SQL
0 vote265 views1 answer
Create a table from one field of another table
SQL
10 votes278 views2 answers
Mysql drop database if exists
SQL