In vs. Exists with different results
user468Jun 22 2011 — edited Jun 30 2011Hi all
I have a general question
Are there any cases where using the exists operator can produce different results/amount of results
Vs. using the IN operator ?
If yes please post an Example
the reason that i'm asking this it's because the exists returns true if the subquery returns at least one row and
it doesn't continue to check , but IN check all the values ,
this is critical for me to know , if i need to returns the amount of rows etc.
Thanks In advanced
Naama
Edited by: naama on Jun 21, 2011 11:52 PM