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 vote170 views1 answer
Oracle execute package dblink
SQL
0 vote170 views1 answer
Ubuntu connect to mssql database
SQL
0 vote170 views1 answer
Varchar format not case sensitive sql
SQL
2 votes137 views1 answer
Sql server find table name
SQL
0 vote144 views1 answer
How to make case insensitive in sql
SQL
4 votes155 views2 answers
Mysql delete user if exists
SQL
0 vote157 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
5 votes138 views2 answers
Sql conn
SQL
2 votes133 views1 answer
Can you use a where clause for a child query
SQL
2 votes193 views1 answer
Username sql
SQL