求助：一些查询问题。求大大帮忙 - 编程论坛

#2

2010-06-03 21:25

在线等、

#3

2010-06-03 21:43

没人么、？

#4

2010-06-03 22:47

先睡觉。

明天早上起来看。。

希望有解答。。。。

#5

2010-06-05 02:34

还是没人回答

#6

aei1352010-06-05 17:46

1.select a.class,b.name,c.subject,c.result from class a,student b,
result c,(select subject,max(result) maxscore from result group by subject) d where a.cid=b.cid and b.sid=c.sid and c.subject=d.subject
and c.result=d.maxscore
2.select a.class,b.name,c.tresult from class,student,(select top 1 sum(result) tresult,sid from result group by sid order by tresult desc) c where a.cid=b.cid and b.sid=c.sid
3.select a.class,b.name,c.tresult from class,student,(select top 1 sum(result) tresult,sid from result group by sid order by tresult) c
where a.cid=b.cid and b.sid=c.sid
4.select top 1 a.class,sum(result) totalscore from class a inner join student b on a.cid=b.cid inner join c on b.sid=c.sid group by a.class order by totalscore desc
5.select top 1 a.class,c.subject,avg(result) avgscore from class a inner join student b on a.cid=b.cid inner join c on b.sid=c.sid group by a.class,c.subject order by avgscore desc
6.select top 1 a.class,c.subject,avg(result) avgscore from class a inner join student b on a.cid=b.cid inner join c on b.sid=c.sid group by a.class,c.subject order by avgscore

#7

lycheeva2010-06-05 23:36

这个简单啊，把表连接起来查询就好了

#8

markjet2010-06-06 11:10

查询条件够多的啊！

#9

2010-06-06 16:19

感谢6L版主大大。。