Question

sql查询女员工最多的部门的名称和女员工人数

Answer 1

select 部门名称,count(sex) from 表名 group by 部门名称 havng count(sex)=(select max(sex) from 表名)

Answer 2

select top 1 count(T1.部门 ) as Amount ,T1.部门 from
( select * from table where 性别=女)T1
group by T1.部门 order by Amount desc

Answer 3

select top(1) sum(女员工) ， 部门 from table group by 部门 order by desc