Difference between in() and =any()

#1

I am trying to understand if there are any differences between the 'in
(select....)' clause and =ANY(select.............)' clause in
performance,.

#2

On Jul 14, 11:31*am, Arun Srini <arunro... (AT) gmail (DOT) com> wrote:

Quote:

I am trying to understand if there are any differences between the 'in
(select....)' clause and =ANY(select.............)' clause in
performance,.

No difference. In fact the ANSI/ISO Standards defines IN () as
=ANY().

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

comp.databases.ibm-db2 comp.databases.ibm-db2