select a.SNAME,AVG(b.SCGRADE)
from S a,SC b
where a.SNO=b.SNO
and a.SNO in(
select SNO
from SC
where SCGRADE<60
group by SNO
having sum(CNO)>2
)
group by a.SNO,a.SNAME
第一个题这样不知道可以不?
from S a,SC b
where a.SNO=b.SNO
and a.SNO in(
select SNO
from SC
where SCGRADE<60
group by SNO
having sum(CNO)>2
)
group by a.SNO,a.SNAME
第一个题这样不知道可以不?
解决方案 »
- 关于php数组,如何显示元素本身字符?
- 知道Paypal支付这块帮帮忙!在线等。。。
- 正则表达式取URL中的指定数据
- 最近在做PHP的测试,有没有模拟网络速度的软件?或者可不可以直接在Windows的什么地方设置一下,让网速变慢?
- 北京有没有想换工作的PHP高手?请和联系(qq 24738916 msn [email protected])
- 关于GD库中生成缩略图的疑问
- 一个多投票的问题
- 关于php和短信等问题,望大家帮帮忙,急呀!!!
- 如何实现权限管理?
- 想学习PHP的来看看,51.net的A型空间大甩卖咯~
- 我破了 google 搜索下拉框的 ajax 回调 url
- 我的是2003 IIS6 怎么装 PHP5.?????
select a.SNAME
from S a,SC b
where a.SNO in(
select SNO
from SC
where SC.CNO=001 OR SC.CNO=002
GROUP BY SNO
HAVING COUNT(SNO)=2
)
group by a.SNO,a.SNAME
select sname from s where sno IN (
select sno from sc where scgrade=(select max(scgrade) from `sc`
where sno in (
select SNO
from SC
where SC.CNO=001 OR SC.CNO=002
GROUP BY SNO
HAVING COUNT(SNO)=2
) and cno=001))
我都经过测试了.第一题,楼上的仁兄回答是正确的...
正确答案应该是:
select a.SNAME,AVG(b.SCGRADE)
from S a,SC b
where a.SNO=b.SNO
and a.SNO in(
select SNO
from SC
where SCGRADE <60
group by SNO
having count(CNO) >=2
)
group by a.SNO,a.SNAME
Note:两门以上.我的理解是包含两门.