题目:将学生的学号及平均成绩及格的学生定义成一个视图pjcj ( )
create view pjcj as select stuid,avg(grade) from sc group by stuid having avg(grade)>=60
create view pjcj as select stuid,avg(grade) from sc whe……继续阅读 »
题目:创建管理系选修了a001号课程的学生的视图guanlixi_view ( )
create view guanlixi_view as select * from student,sc where cid=’a001’ and depart=’管理系’
create view guanlixi_view as select student.*,sc.……继续阅读 »