Hello,
What is the result for the given scenario:
Select * from table1 where (cond) ANY/IN/ALL/EXISTS/etc (sub query result empty)
If this is the question given and asked how many rows does it return then the answer would be ??
I know when we use > ALL for the above scenario it gives all the rows of table1.
Please add your points.