下面的语句能写成一句完成任务吗？

[oXinPingQiHe12]

SELECT "语文", round(sum(iif(语文>=90,1,0))/count(*)*100,2) AS 优秀率, round(sum(iif(语文>=75,1,0))/count(*)*100,2) AS 良好率, round(sum(IIf(语文>=65,1,0))/count(*)*100,2) AS 及格率, round(avg(语文),2) AS 平均分 FROM cj WHERE 班级=1;
union all
SELECT "语文", round(sum(iif(语文>=90,1,0))/count(*)*100,2) AS 优秀率, round(sum(iif(语文>=75,1,0))/count(*)*100,2) AS 良好率, round(sum(IIf(语文>=65,1,0))/count(*)*100,2) AS 及格率, round(avg(语文),2) AS 平均分 FROM cj WHERE 班级=2;
UNION ALL SELECT "语文", round(sum(iif(语文>=90,1,0))/count(*)*100,2) AS 优秀率, round(sum(iif(语文>=75,1,0))/count(*)*100,2) AS 良好率, round(sum(IIf(语文>=65,1,0))/count(*)*100,2) AS 及格率, round(avg(语文),2) AS 平均分 FROM cj WHERE 班级=3;

[shoppo0505]

这不就是1句么,:)

• 打赏
• 举报

回复 赞

[oXinPingQiHe12]

问题补充 我是说将班级做一个循环，只用一句就可以得到多个班的数据，上面的语句我要复制多遍后，还要改班级数，不用改班级数，如何实现

• 打赏
• 举报

回复 赞

[骑着蜗牛去爬山]

group by 班级 或者 join master..spt_values s on 班级=s.number where type='p'

• 打赏
• 举报

回复 赞