421. 以下SQL语句正确的有 ()
选项:
A:
A:SELECT cust_name FROM Customers WHERE cust_state IN ('IL','IN','MI') UNION SELECT cust_name FROM Customers WHERE cust_name = 'Fun4All';(正确答案)
B:
B:SELECT cust_name FROM Customers WHERE cust_state IN ('IL','IN','MI') UNION SELECT cust_contact FROM Customers WHERE cust_name= 'Fun4All';
C:
C:SELECT * FROM Customers WHERE cust_state IN ('IL','IN','MI') UNION SELECT * FROM Customers WHERE cust_name = 'Fun4All';(正确答案)
D:
D:SELECT * FROM Customers WHERE cust_state IN ('IL','IN','MI') UNION SELECT cust_name FROM Customers WHERE cust_name = 'Fun4All';
发布时间:2024-05-07 19:31:40