假设我在 SQL 中有一个 table1,如下所示。
Team PlayerID
Team1 12
Team2 56
Team1 78
Team1 96
Team3 23
Team2 45
Team3 89
Team3 78
现在我有一个新的 table2 作为
PlayerID Gender
12 Male
56 Female
78 Female
96 Male
23 Female
45 Male
89 Female
78 Female
有没有办法列出所有只有女性性别的团队?
您可以使用join
,group by
以及having
:
select t.team
from teams t join
players p
on p.playerid = t.playerid
group by t.team
having min(gender) = max(gender) and min(gender) = 'Female';
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句