建立一个名为GZ1的视图,用来显示工资比江苏的所有人的工资都高的员工号、姓名和工资,下列命令正确的是______。
A.SELECT 员工号,姓名,工资 FROM 员工表; WHERE 工资>=ANY(SELECT 工资 FROM 员工表; WHERE 籍贯="江苏"); INTO VIEW GZ1
B.SELECT员工号,姓名,工资 FROM 员工表; WHERE 工资>=ALL(SELECT 工资 FROM 员工表; WHERE 籍贯="江苏"); INTO VIEW GZ1;
C.CREATE VIEW GZ1 AS SELECT 员工号,姓名,工资 FROM 员工表; WHERE 工资>=ANY(SELECT 工资 FROM 员工表; WHERE 籍贯="江苏")
D.CREATE VIEW GZ1 AS SELECT员工号,姓名,工资 FROM 员工表; WHERE 工资>=ALL(SELECT 工资 FROM 员工表; WHERE 籍贯="江苏");