视图练习 1.填空题 实验:在数据库schooldb中,创建和应用视图①创建视图。统计每位同学所有课程的总分,显示学号、姓名和总分列。 select…
- User
视图练习 1.填空题 实验:在数据库schooldb中,创建和应用视图①创建视图。统计每位同学所有课程的总分,显示学号、姓名和总分列。 select student.studentno as 学号,studentname as 姓名,sum(studentresult) as总分 from student inner join_ on() group by student.; create. fs_view as select student.studentno as学号,studentname as 姓名,sum(studentresult) as总分 from student inner join on(_____) group by student.______; show create view fs_view;
- Assistant
实验:在数据库schooldb中,创建和应用视图 ①创建视图。统计每位同学所有课程的总分,显示学号、姓名和总分列。 select student.studentno as 学号,studentname as 姓名,sum(studentresult) as 总分 from student inner join score on student.studentno = score.studentno group by student.studentno;
create view fs_view as select student.studentno as 学号, studentname as 姓名, sum(studentresult) as 总分 from student inner join score on student.studentno = score.studentno group by student.studentno;
show create view fs_view;
- User
视图练习 1.填空题 实验:在数据库schooldb中,创建和应用视图①创建视图。统计每位同学所有课程的总分,显示学号、姓名和总分列。 select student.studentno as 学号,studentname as 姓名,sum(studentresult) as总分 from student inner join_ on() group by student.____; create. _fs_view as select student.studentno as学号,studentname as 姓名,sum(studentresult) as总分 from student inner join on(_) group by student._____; show create view fs_view;
- Assistant
实验:在数据库schooldb中,创建和应用视图 ①创建视图。统计每位同学所有课程的总分,显示学号、姓名和总分列。 select student.studentno as 学号,studentname as 姓名,sum(studentresult) as 总分 from student inner join score on student.studentno = score.studentno group by student.studentno;
create view fs_view as select student.studentno as 学号, studentname as 姓名, sum(studentresult) as 总分 from student inner join score on student.studentno = score.studentno group by student.studentno;
show create view fs_view;