Which SQL statement would retrieve from the table the n…

View the exhibit and examine the description of the PRODUCT_INFORMATION table.

Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

View the exhibit and examine the description of the PRODUCT_INFORMATION table.

Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

A.
SELECT COUNT (DISTINCT list_price)
FROM product_information
WHERE list_price is NULL

B.
SELECT COUNT (NVL(list_price, 0))
FROM product_information
WHERE list_price is NULL

C.
SELECT COUNT (list_price)
FROM product_information
WHERE list_price i= NULL

D.
SELECT COUNT (list_price)
FROM product_information
WHERE list_price is NULL



Leave a Reply 0

Your email address will not be published. Required fields are marked *