Sql count condition

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 ...

Sql count if

COUNT(CASE WHEN <condition> THEN 1 END)

-1

Source: modern-sql.com

Sql count condition

SELECT count(CASE WHEN gender = 'F' THEN 1 ELSE NULL END) women_count,
       count(CASE WHEN gender = 'M' THEN 1 ELSE NULL END) men_count
FROM people;

-2

Similar codes

2 votes346 views1 answer
Tsql copy table
SQL
0 vote392 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote336 views2 answers
How to combine diff colmun value using group by postgres
SQL
3 votes331 views1 answer
Ms sql skip take
SQL
0 vote369 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote341 views1 answer
Drop procedure sql
SQL
1 vote359 views2 answers
Mysql trim spaces
SQL
0 vote348 views1 answer
Materialized view redshift
SQL
0 vote333 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote327 views3 answers
Get count of null in column sql
SQL