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 vote203 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
10 votes187 views2 answers
Mysql drop database if exists
SQL
0 vote163 views1 answer
Output to file mysql
SQL
1 vote223 views1 answer
Mysql tables max count
SQL
0 vote181 views1 answer
Sql pad left 0
SQL
0 vote156 views1 answer
Sql table to store status
SQL
0 vote146 views1 answer
Sql select rows with simlar names
SQL
0 vote230 views1 answer
Sql decimal to 2 places
SQL
3 votes239 views2 answers
How to modify rows in SQL Server
SQL
0 vote176 views1 answer
Mysql case when on date
SQL