ANY and ALL Operators vs IN operator
user468Feb 24 2011 — edited Feb 24 2011Hi all,
i'm in the middle of learning the sql functions & operators ,now i'm learning about subqueries.
i've learned abot the IN / NOT IN operator.now i'm kind of learning about the ANY & ALL .
which the first question is : do i need to delve into this operators ? does anyone really use the any & all operator ,
i'm asking cause ANY & ALL kind of confuses me vs the IN operator ?
Thanks in Advanced
Naama