Answers for "sql server where clause with count"

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;

Posted by: Guest on April-21-2021

Code answers related to "sql server where clause with count"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql server where clause with count"

Code answers related to "sql server where clause with count"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql server where clause with count"

Code answers related to "sql server where clause with count"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us