How many rows are returned?

You have the following table definition:

CREATE TABLE Product

(ID INTEGER PRIMARY KEY,

Name VARCHAR(20),

Quantity INTEGER)

The Product table contains the following data.

You execute the following statement:

SELECT Name FROM Product WHERE Quantity IS NOT NULL

How many rows are returned?
A . 0
B . 1
C . 2
D . 3
E . 4

View Answer

Answer: D