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

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.

answersecurity intrusion;