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

View the Exhibit and examine the data in the PRODUCT_INFORMATION table. 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?

View the Exhibit and examine the data in the PRODUCT_INFORMATION table. 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.



Leave a Reply 2

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


rahul khillare

rahul khillare

tell me answer of this question

Ab Hin

Ab Hin

Answer is: C