下面关于修改视图的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
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
C
举一反三
- 以下是修改视图的语句是 A: create or replace view st1 as select* from student; B: alter view st1 as select name from student join class on student.cid=class.id; C: alter table st1 modify class int(3); D: create or replace table st1 as select* from student;
- 下列哪条语句可以创建视图( )。 A: create view v_student as select * from student; B: alter view v_student as select * from student; C: drop view v_student as select * from student; D: sp_help view v_student as select * from student;
- 下面定义视图的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.1*parice as ‘涨价’ from shop
- 修改视图vsex以查询stinfo表中女学生信息的正确语句是（ ）。 A: ALTER VIEW vsex AS SELECT * FROM stinfo WHERE 姓名 ='女' B: MODIFY TABLE vsex AS SELECT * FROM stinfo WHERE 性别= '女' C: ALTER VIEW vsex AS SELECT * FROM stinfo WHERE 性别 ='女' D: ALTER TABLE vsex AS SELECT * FROM stinfo WHERE 性别= '女'
- 在student表上创建view_stu视图,正确的语句是( )。 A: CREATE VIEW view_stu IS SELECT * FROM student; B: CREATE VIEW view_stu AS SELECT * FROM student; C: CREATE VIEW view_stu SELECT * FROM student; D: CREATE VIEW SELECT * FROM student AS view_stu;
内容
- 0
使用SQL语句查询视图v_student的所有数据，下列语句正确的是_______。 A: create view v_studentas....... B: alter view v_studentas....... C: select * from v_student D: drop view v_student
- 1
修改视图stu的结构应使用语句ALTER VIEW ss【1】SELECT * FROM s_view WHERE score>=60
- 2
下面关于“CREATE VIEW v_goods AS SELECT id, name FROM goods”描述错误的是
- 3
修改视图的SQL命令是（ ） A: update view B: edit view C: alter table D: alter view
- 4
建立信息系统学生的视图是（） A: CREATE VIEW is_student AS SELECT sno,sname,sage FROM student WHERE sdpt='is'; B: CREATE VIEW is_student SELECT sno,sname,sageFROM WHERE sdpt='is'; C: CREATE VIEW is_student AS select sno,sname,sage FROM WHERE sdpt='is' D: CREATE VIEW is_student AS SELECT sno,sname,sage WHERE sdpt='is';