要得出这样的效果
-- Unit M402 S366 S367 S375 S376
-- ---------------------------------------
-- SCC103 36.5 64 62.5 63.4 57.4
-- SCC104 54 72.5 58.3 59 53.1
-- SCC105 58.5 54 62.9 61.3
-- SCC107 58.5 54 62.9 61.3
-- SCC108 61.5 71.5 61.5 61.7 63.4
-- SCC109 58.5 74 60.8 59.9
-- SCC203 75.7 62.7 64.5
-- SCC204 68 66.6 63.2
-- SCC208 61.5 68.5
-- SCC209 68.3 69.7而我现在用
create view averageM402 (Unit,M402) AS select unit_code,AVG(result) from e,s where e.stu_no in (select stu_no from s where degree ='m402' ) group by unit_code;只能得出独立单一的视图如:
-- Unit M402
-- -----------------
-- SCC103 36.5
-- SCC104 54
-- SCC105 58.5
-- SCC107 58.5
-- SCC108 61.5
-- SCC109 58.5
-- SCC203 75.7
-- SCC204 68
-- SCC208 61.5
-- SCC209 68.3请教如何将单一的视图合并成效果图,或者是先合并搜索结果?
请教,谢谢!
-- Unit M402 S366 S367 S375 S376
-- ---------------------------------------
-- SCC103 36.5 64 62.5 63.4 57.4
-- SCC104 54 72.5 58.3 59 53.1
-- SCC105 58.5 54 62.9 61.3
-- SCC107 58.5 54 62.9 61.3
-- SCC108 61.5 71.5 61.5 61.7 63.4
-- SCC109 58.5 74 60.8 59.9
-- SCC203 75.7 62.7 64.5
-- SCC204 68 66.6 63.2
-- SCC208 61.5 68.5
-- SCC209 68.3 69.7而我现在用
create view averageM402 (Unit,M402) AS select unit_code,AVG(result) from e,s where e.stu_no in (select stu_no from s where degree ='m402' ) group by unit_code;只能得出独立单一的视图如:
-- Unit M402
-- -----------------
-- SCC103 36.5
-- SCC104 54
-- SCC105 58.5
-- SCC107 58.5
-- SCC108 61.5
-- SCC109 58.5
-- SCC203 75.7
-- SCC204 68
-- SCC208 61.5
-- SCC209 68.3请教如何将单一的视图合并成效果图,或者是先合并搜索结果?
请教,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货