建立表Employee的视图Em_view,正确的SQL命令是

admin2015-08-25  19

问题 建立表Employee的视图Em_view,正确的SQL命令是

选项 A、CREATE VIEW Em_view WHLIE 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…AS…建立视图,C选项格式正确。
转载请注明原文地址:https://kaotiyun.com/show/5qEp777K
0

最新回复(0)