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

admin2016-12-07  17

问题 建立表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

解析 本题使用SOL命令创建视图。使用CREATE VIEW命令创建视图,其语法为:
CREATE VIEW view_name AS
SELECT column_name(s)FROM table_name
WHERE condition
转载请注明原文地址:https://kaotiyun.com/show/myIp777K
0

相关试题推荐
最新回复(0)