一、原题
View the Exhibit and examine the structure of the PRODUCTS table.
Evaluate the following query:
SQL> SELECT prod_name
FROM products
WHERE prod_id IN
(SELECT prod_id
FROM products
WHERE prod_list_price =
(SELECT MAX(prod_list_price)
FROM products
WHERE prod_list_price <
(SELECT MAX(prod_list_price) FROM products)));
What would be the outcome of executing the above SQL statement?
A. I
Evaluate the following query:
SQL> SELECT prod_name
FROM products
WHERE prod_id IN
(SELECT prod_id
FROM products
WHERE prod_list_price =
(SELECT MAX(prod_list_price)
FROM products
WHERE prod_list_price <
(SELECT MAX(prod_list_price) FROM products)));
What would be the outcome of executing the above SQL statement?
A. I