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 vote109 views1 answer
Import excel to sql
SQL
0 vote105 views2 answers
Sql select inside select
SQL
2 votes104 views1 answer
Sql server case sensitive search
SQL
2 votes114 views1 answer
Mysql change data type of column
SQL
-1 vote103 views1 answer
Mysql #1064 error
SQL
-1 vote102 views3 answers
Create temp table in sql
SQL
10 votes87 views1 answer
Oracle dependency
SQL
0 vote130 views1 answer
Oracle step procedure
SQL
0 vote102 views1 answer
Get create sql of hibernqte entity
SQL
5 votes104 views3 answers
Mysql check if null or empty string
SQL