Which statement is true regarding sub queries?

Which statement is true regarding sub queries?

Which statement is true regarding sub queries?

A.
The LIKE operator cannot be used with single- row subqueries.

B.
The NOT IN operator is equivalent to IS NULL with single- row subqueries.

C.
=ANY and =ALL operators have the same functionality in multiple- row subqueries.

D.
The NOT operator can be used with IN, ANY, and ALL operators in multiple- row subqueries.

Explanation:
Using the ANY Operator in Multiple-Row Subqueries
The ANY operator (and its synonym, the SOME operator) compares a value to each value
returned by a subquery.
<ANY means less than the maximum.
>ANY means more than the minimum.
=ANY is equivalent to IN
Using the ALL Operator in Multiple-Row Subqueries
The ALL operator compares a value to every value returned by a subquery.

>ALL means more than the maximum and
<ALL means less than the minimum.
The NOT operator can be used with IN, ANY, and ALL operators.



Leave a Reply 1

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


Eamon

Eamon

None of these are correct.
The statement …
The NOT operator can be used with IN, ANY, and ALL operators.
… is false.

NOT can be used with IN. However it cannot be used directly with ANY nor with ALL.