博客园-eRongs Geolife Blog-最新评论http://www.cnblogs.com/cosophy/CommentsRSS.aspxBlogging 3S , Programming ,etc.zh-cnFri, 30 May 2008 11:36:00 GMTFri, 30 May 2008 11:36:00 GMTcnblogsre: 交叉表查询---统计成绩等（第二问不会）http://www.cnblogs.com/cosophy/archive/2007/06/02/768102.html#768565cosophycosophySat, 02 Jun 2007 03:44:00 GMThttp://www.cnblogs.com/cosophy/archive/2007/06/02/768102.html#768565不行吧,你试下
@supersun-mo


cosophy 2007-06-02 11:44 发表评论
]]>re: 交叉表查询---统计成绩等（第二问不会）http://www.cnblogs.com/cosophy/archive/2007/06/02/768102.html#768410supersun-mosupersun-moSat, 02 Jun 2007 01:09:00 GMThttp://www.cnblogs.com/cosophy/archive/2007/06/02/768102.html#768410第二个可以在第一个查询的基础上再与第一个表做一个连接，得到含班级列的记录集，根据班级分组一下应该就可以得到了

supersun-mo 2007-06-02 09:09 发表评论
]]>re: 交叉表查询---统计成绩等（第二问不会）http://www.cnblogs.com/cosophy/archive/2007/06/02/768102.html#768326谢小漫谢小漫Fri, 01 Jun 2007 17:03:00 GMThttp://www.cnblogs.com/cosophy/archive/2007/06/02/768102.html#768326FROM [SELECT StuInfo.Class, StuInfo.Name, Sum(StuScore.Score) AS Score之总计
FROM StuInfo INNER JOIN StuScore ON StuInfo.StuID = StuScore.StuID
GROUP BY StuInfo.Class, StuInfo.Name
ORDER BY Sum(StuScore.Score) DESC]. AS [%$##@_Alias]
GROUP BY StuInfo.Class
ORDER BY Max([%$##@_Alias].Score之总计) DESC;

20分钟内，含access建表。
手写还真不知道怎么写好。

谢小漫 2007-06-02 01:03 发表评论
]]>