Darren Burns Darren Burns - 9 months ago 81
SQL Question

Multiple-Row Subquery Operators

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.

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




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.

Answer Source

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