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 vote199 views1 answer
Sql run multiple updates in one query
SQL
0 vote201 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote221 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote179 views1 answer
How to create an SQL save method in ruby
SQL
0 vote210 views1 answer
Php select data from mysql database without column name
SQL
1 vote195 views1 answer
Sql bitwise operators
SQL
0 vote154 views1 answer
Flask_sqlalchemy install
SQL
0 vote216 views1 answer
Sql delete dastabase
SQL
0 vote198 views1 answer
Print mysql
SQL
1 vote196 views1 answer
SQLite order random
SQL