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 vote185 views1 answer
Show database not empty tables postgres
SQL
0 vote203 views1 answer
Mysql type for large numbers with many decimal
SQL
20 votes199 views6 answers
Change password in mysql
SQL
1 vote197 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote200 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote184 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote194 views1 answer
How to insert multiple rows in mysql using laravel
SQL
12 votes193 views1 answer
Script to add new column in table sql
SQL
0 vote192 views1 answer
Mysql table variables
SQL
1 vote200 views1 answer
Vagrant mysql downgrade version
SQL