修改学生姓名是赵成刚的视图“view-sp”,为视图指定列明
create view view2(sno,savg,sname)as select Student.Sno,Sname,AVG((cast(StudentCourse.Grade as int)))from Student join StudentCourseon StudentCourse.Sno=Student.Snogroup by Student.Sno,Student.Sname即可,反正Sno已经保证唯一了,再加上Sname也无法再干扰什么了。
上一篇:代码雨怎么弄
热门标签: