Multiple-Row Subquery Operators

Question

I just finished taking an exam for an Intro to Oracle class. I failed to answer this question correctly for, what I believe to be, obvious reasons.

QUESTION: Which comparison operator cannot be used with multiple-row subqueries?

A. ALL

B. ANY

C. IN

D. All of the above

As far as my understanding goes, all of these are comparison operators specifically used for multiple-row subqueries. Is this a faulty question, or is there something I'm missing? [I understand that the ANY and ALL operator require a single-row operator (i.e > < = != etc) to be used in conjunction, however this is not addressed in the question.] Just looking for some confirmation that I'm not mistaken before I email my professor.

Thanks in advance.

Yes question is wrong. Actually last option should None of the above — Pரதீப்
– Pரதீப், Commented Oct 22, 2016 at 4:18
English is funny with double negation. The best way to fix the question is to keep the answers, and change "cannot" to "can" in the question. — user5683823
– user5683823, Commented Oct 22, 2016 at 13:58

Aditya · Accepted Answer · 2016-10-22 05:32:24Z

1

All of them can be used with multi row sub query. Confirmation from the oracle itself https://oracle-base.com/articles/misc/all-any-some-comparison-conditions-in-sql#any

answered Oct 22, 2016 at 5:32

Aditya

1231 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multiple-Row Subquery Operators

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related