（142）View the Exhibit and examine the structure of the PRODUCTS table. Evaluate the following query:

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. It produces an error.

B. It shows the names of all products in the table.

C. It shows the names of products whose list price is the second highest in the table.

D. It shows the names of all products whose list price is less than the maximum list price.

答案：（C）

ITPub博客

OCP 1Z0 051 142