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 vote316 views1 answer
Close sql query vb.net
SQL
1 vote302 views1 answer
Sqlite check if row exists
SQL
0 vote298 views1 answer
Add column to table with default value plsql
SQL
1 vote327 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote325 views1 answer
Sqlite3_open_v2
SQL
0 vote302 views1 answer
Limiting query result using where in sql
SQL
8 votes328 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote314 views1 answer
Do you know sql
SQL
5 votes335 views1 answer
Mysql add user with all privileges
SQL
0 vote318 views1 answer
How to check event scheduler status mysql
SQL