Question

When coded in a WHERE clause, which of the following search conditions will not return a result set that includes all invoices with an InvoiceTotal value of $1000 or less?
a. InvoiceTotal BETWEEN 0 AND 1000
b. InvoiceTotal IN (0,1000)
c. NOT (InvoiceTotal > 1000)
d. InvoiceTotal <= 1000

Answer 1

Answer:

b. InvoiceTotal IN (0,1000)

Explanation:

It is important to reliaze that the question is asked to check a range between 0 and 1000.

a. InvoiceTotal BETWEEN 0 AND 1000 satisfies the condition

c. NOT (InvoiceTotal > 1000) excludes the values greater than 1000, and satisfies the condition

d. InvoiceTotal <= 1000 satisfies the condition

However, in InvoiceTotal IN (0,1000), the "IN (0,1000)" part checks that if InvoiceTotal is either 0 or 1000.