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 vote115 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote119 views1 answer
Sql count more than 1
SQL
2 votes109 views1 answer
Mysql cannot delete or update a parent row
SQL
3 votes89 views1 answer
Sql set null
SQL
0 vote119 views1 answer
Foreign key type uniqu mysql
SQL
0 vote109 views1 answer
Select other columns with distinct
SQL
0 vote127 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote141 views1 answer
Consecutive numbers sql
SQL
0 vote118 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote112 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL