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 vote147 views2 answers
Postgres default user
SQL
0 vote223 views1 answer
Shortcut run sql pgadmin
SQL
3 votes149 views3 answers
Sql last week
SQL
0 vote118 views1 answer
Sqlalchemy existing database
SQL
3 votes146 views2 answers
Sql paging query
SQL
5 votes146 views1 answer
JBDC
SQL
1 vote145 views1 answer
What is int in mysql
SQL
58 votes371 views6 answers
Create new user in postgres
SQL
7 votes160 views2 answers
Sql server drop temp table if exists
SQL
5 votes176 views1 answer
Get table columns from sql
SQL