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

2 votes104 views2 answers
Get all columns from table sql
SQL
0 vote117 views2 answers
Mysql update two tables at once
SQL
0 vote117 views2 answers
Default constraint in ms sql
SQL
0 vote132 views1 answer
Sql decimal to 2 places
SQL
3 votes109 views1 answer
Sql select all
SQL
8 votes115 views1 answer
Oracle create datafile
SQL
0 vote109 views1 answer
Mysql database is not starting in xampp
SQL
10 votes125 views2 answers
Show tables in schema oracle
SQL
11 votes298 views4 answers
Round in sql
SQL
3 votes112 views1 answer
How to remove characters from string in mysql
SQL