题目内容

下面定义视图的SQL语句，哪一个是错误的？（）

A. create view VIEW1 as select id,name,sex from users
B. create view VIEW2 as select count() as studentTotal,classname from student
C. create view VIEW3 as select name,price from
D. create view VIEW4 as select logdate,price,1.1parice as ‘涨价’ from shop

查看答案

搜索结果不匹配？点我反馈

更多问题

删除视图的SQL命令是（ C ）

A. delete view
B.edit view
C.drop table
D.alter view

查看答案

下面关于修改视图的SQL语句，那个是正确的（）。

A.alter view VIEW01 as select * from users order by age desc
B.alter view VIEW02 as select name,avg(score) as avgScore from studentScore
C.alter view VIEW03 as select top 10 id,name,password from admin order by id
D.alter view VIEW04 as select * from stuent,class where student.classid=class.classid order by class.classid

查看答案