select a.*
from renkou a, (select xb, dz, nl
from renkou
where xb = '男' and dz not in ('温州', '成都')
group by xb, dz, nl
having count(1) >= 3) b
where a.xb = b.xb and a.dz = b.dz and a.nl = b.nl
是这样吗？
题主参考如下语句:
select 列 from 表 where xb='男' and DZ not in ('温州','成都') and NL>=3
祝好运 望采纳。
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024