OCP-1Z0-051-2015-43题

QUESTION NO: 43

Exhibit contains the structure of PRODUCTS table:

Evaluate the following query:
What would be the outcome of executing the above SQL statement?
A. It produces an error
B. It shows the names of products whose list price is the second highest in the table.
C. It shown the names of all products whose list price is less than the maximum list price
D. It shows the names of all products in the table
Answer: B

Explanation:

1、语句可以出结果，A错误

2、拆分上面sql语句，首先运行子句查询出价格最高的产品的价格

sh@TESTDB> SELECT MAX(prod_list_price)FROM products;

MAX(PROD_LIST_PRICE)

--------------------

             1299.99

3、低于价格最高的，即价格次高的产品。按题意，故选C.

sh@TESTDB> SELECT MAX(prod_list_price)FROM products

  2  WHERE prod_list_price < 1299.99;

MAX(PROD_LIST_PRICE)

--------------------

             1099.99