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.