帮我做sql视图的管理的几个题

2024-12-03 22:09:30
推荐回答(2个)
回答1:

你这里没判念码有提供字段.!暂时掘哪用中文代替了.

1.create view VI_Student
as
select * from student where 班级名='01数据库';

2.creaet view V_CourseSub
as
select 课程名称,学分 from Course where
报名人数>30;

3.create view V_Stucou
as
select count(选课的高首Id) from 表名;

4.--忘记怎么加密去了.!

5.drop view V_Stucou;

回答2:

10分???