中国审计-设有客户表(客户号CHAR(4),姓名NCHAR(4
设有客户表(客户号CHAR(4),姓名NCHAR(4),薪资INT),创建“薪资大于5000的客户”视图的命令是____。
['A:CREATEVIEWv1(客户号CHAR(4),姓名NCHAR(4),薪资INTCHECK(薪资>5000))', 'B:CREATEVIEWv1SELECT*FROM客户表WHERE薪资>5000', 'C:CREATEVIEWv1SELECT*FROM客户表CHECK(薪资>5000)', 'D:CREATEVIEWv1ASSELECT*FROM客户表WHERE薪资>5000']