逍凌渺宇 发表于 2012-8-17 17:09
select SCname from (select * from student where Ssex='女') having count(Ssex) >3 group by SCna ...
你可以再试一下,是错误的哦,而且语法也有错误的吧。。having要放在group后面。。
select SCname ,count(*)as 人数 from student where Ssex='女'
group by SCname
having count(*)>3
这样就可以了。 |
|