SQL练习：求每班每门功课前55名平均分

xiaoni · 发表于 2010-6-14 11:12

ggggggggggggg

opq876 · 发表于 2010-6-14 11:21

进来学习下[em01]

yuliang-1918 · 发表于 2011-6-28 16:08

pujizhongxue · 发表于 2012-4-29 07:57

前来认真学习，看看能不能提高一下自己。

yl_li · 发表于 2012-4-29 11:17

看看最佳答案

w1098 · 发表于 2013-1-8 21:52

本帖最后由 w1098 于 2013-1-9 00:07 编辑

transform sum(成绩) select 班级 from(select top 55 avg(语文) as 成绩,"语文" as 科目,班级 from[Sheet1$] group by 班级 union all select top 55 avg(数学) as 成绩,"数学" as 科目,班级 from[Sheet1$] group by 班级 union all select top 55 avg(英语) as 成绩,"英语" as 科目,班级 from[Sheet1$] group by 班级 union all select top 55 avg(政治) as 成绩,"政治" as 科目,班级 from[Sheet1$] group by 班级 union all select top 55 avg(历史) as 成绩,"历史" as 科目,班级 from[Sheet1$] group by 班级 union all select top 55 avg(地理) as 成绩,"地理" as 科目,班级 from[Sheet1$] group by 班级 union all select top 55 avg(生物) as 成绩,"生物" as 科目,班级 from[Sheet1$] group by 班级) group by 班级 pivot 科目

复制代码

w1098 · 发表于 2013-1-9 00:10

vbyou127 · 发表于 2016-2-16 18:59

fdfdsd

		自动登录	找回密码
密码			注册