如何使用单个命令显示noof男性和女性 [英] how can i display noof Male and Female with single command

问题描述

我有一个像人一样的桌子

性别名称
abc男
lmk FeMale
jmn男
abc男
lmk FeMale
lmk FeMale

我想数一下男3女3的性别

在SQL Server中仅使用单个选择命令

i have one Table like person

Name Gender
abc Male
lmk FeMale
jmn Male
abc Male
lmk FeMale
lmk FeMale

i want to count Gender that Male 3 and Female 3

using only single select commnad in sql server

推荐答案

您的意思是这个吗?

You mean this ?

select Gender, Count(Gender) as nr
from Person
group by Gender

选择性别，COUNT (性别)
来自人
按性别分组

SELECT gender,COUNT(gender)
FROM person
GROUP BY gender

这篇关于如何使用单个命令显示noof男性和女性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！