Re: SQL - SOME - ANY

There isn't supposed to be any.

Check the SQL Reference manual: Comparison Operators - ca. page 3-6, table ca. 3-4.

• ANY
• SOME IN

are supposed to be synonymous,
although your example with > ANY / > SOME seems to have an optimiser option available that is not available to = ANY/ = SOME / IN

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Kai Sodemann wrote in message
<01bedd8e$dea67ce0$6e49100a_at_pc910-sode.seurope.ikea.com>...
>can anybody tell me the difference between SOME and ANY in a query ?
>
>select col1
>from tab1
>where
>10>any(col1, col2);
>
>select col1
>from tab1
>where
>10>some(col1, col2);
Received on Tue Aug 03 1999 - 05:27:51 CDT