Diffence between Quantified Predicates: IN , ANY, and SOME?

Praveen · *nix forums beginner Joined: 10 Feb 2005 Posts: 30

Thank you very much for your kind reply.

Mark Yudkin · *nix forums Guru Wannabe Joined: 29 May 2005 Posts: 117

ANY = SOME.
IN = =ANY = =SOME.
also: NOT IN = <>ALL.
All of which is fully clear from the documentation, which states the
equivalence, and which should be your first source of information.

"Praveen" <praveen.unnithan@gmail.com> wrote in message
news:1107922416.532818.15270@o13g2000cwo.googlegroups.com...

Praveen · *nix forums beginner Joined: 10 Feb 2005 Posts: 30

Hi,
Hi I am a newbie in DB2 and Mainframe.I would like to know if there is
any diffence between the Quantified Predicates: IN , ANY, and SOME.

Thank you very much for your valuable time.

Regards,
Praveen.

Google