下列哪条语句可以创建视图( )。
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;
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;
举一反三
- 在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;
- 以下是修改视图的语句是 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;
- 使用SQL语句查询视图v_student的所有数据，下列语句正确的是_______。 A: create view v_studentas....... B: alter view v_studentas....... C: select * from v_student D: drop view v_student
- 以下______语句查询表student中第3条到第10条记录 。 A: SELECT * FROM student LIMIT 2,8; B: SELECT * FROM student LIMIT 2,9; C: SELECT * FROM student LIMIT 3,10; D: SELECT * FROM student LIMIT 3,9;
- 下列 SQL 语句select * from student where sno = '05880101'union select * from student where sno = '05880102'与此查询语句等价的选项是( )。 A: select * from student where sno= '05880101' and sno= '05880102' B: select * from student where sno= '05880101' or sno= '05880102' C: select * from student where sno= '05880101' D: select * from student where sno= '05880102'