单选题
建立表Employee的视图Em_view，正确的SQL命令是
A、
CREATE VIEW Em view WH[JE SELECT职工号，工资FROM Employee
B、
CREATE AS Em view VIEW SELECT职工号，工资FROM Employee
C、
CREATE VIEW Em view AS SELECT 职工号，工资FROM Employee
D、
CREATE VIEW Em view SELECT 职工号，工资FROM Employee
【正确答案】
C
【答案解析】
解析：本题使用SQL命令创建视图。使用CREATE VIEW命令创建视图，其语法为： CREATE VIEW view_name AS SELECT column_name(s)FR OM table_name WHERE condition
提交答案
关闭