Prev Question
Next Question

View the Exhibit and examine the data in the PRODUCT_INFORMATION table.

5a10492b6a067 - What changes would you make in the statement to get the desired result?

There are some products listed in the PRODUCT_INFORMATION table that have no value in the LIST_PRICE column. You issued the following SQL statement to find out the PRODUCT_NAME for these products:
SELECT product_name, list_price
FROM product_information
WHERE list_price = NULL;
The query returns no rows.

What changes would you make in the statement to get the desired result?

A.
Change the WHERE clause to WHERE list_price = 0

B.
Change the WHERE clause to WHERE list_price = ‘ ‘.

C.
Change the WHERE clause to WHERE list_price IS NULL.

D.
In the WHERE clause, enclose NULL within single quotation marks.

E.
In the WHERE clause, enclose NULL within double quotation marks.

Prev Question
Next Question

Leave a Reply

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