Sql count if

Sql count

/*COUNT(column_name) will return the number of rows from the column 
that are not NULL*/
SELECT COUNT(column_name)
FROM table_name;

/*COUNT(*) will return the number of rows from the table*/
SELECT COUNT(*)
FROM table_name;

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

0 vote131 views2 answers
Postgresql change user role grant
SQL
1 vote135 views1 answer
Get last week data in mysql
SQL
0 vote129 views1 answer
Mysql server not starting in xampp in mac
SQL
3 votes210 views3 answers
Mysql get table size
SQL
0 vote130 views2 answers
Find Overlapping sql
SQL
2 votes126 views1 answer
Sql to char function with date
SQL
31 votes148 views4 answers
How to get duplicate records with multiple field in sql
SQL
33 votes138 views6 answers
Change column name in mysql
SQL
1 vote151 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote161 views1 answer
Hour differeence in mysql
SQL