047-138

138. View the Exhibit and examine the structure of the ORDER_ITEMS table.

Examine the following SQL statement:

SELECT order_id, product_id, unit_price

FROM order_items WHERE unit_price = (SELECT MAX(unit_price)

FROM order_items GROUP BY order_id).

You want to display the PRODUCT_ID of the product that has the highest

UNIT_PRICE per ORDER_ID.

What correction should be made in the above SQL statement to achieve this?

A. Replace = with the IN operator.

B. Replace = with the >ANY operator.

C. Replace = with the >ALL operator.

D. Remove the GROUP BY clause from the subquery and place it in the main query.

Answer: A

SELECT MAX(unit_price) FROM order_items GROUP BY order_id 会按order_id

返回多条记录

需试验

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-718957/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11312660/viewspace-718957/