select t.* from ec_test_tbl t;
select
t.name as 姓名,
count(1) as 人数 ,
(
select count(1)
from ec_test_tbl tt where 1=1
and tt.name = t.name
and tt.sex = '男'
group by t.name
) as 男性人数
from ec_test_tbl t where 1=1
group by t.name
having count(1) > 1
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024