Re: SQL - SOME - ANY

There is no difference. SOME is a synonym for ANY.

Kai Sodemann <Kai.Sodemann_at_memo.ikea.com> schrieb in im Newsbeitrag: 01bedd8e$dea67ce0$6e49100a_at_pc910-sode.seurope.ikea.com...
> Hi,
> can anybody tell me the difference between SOME and ANY in a query ?
>
> e.g.
> select col1
> from tab1
> where
> 10>any(col1, col2);
>
> select col1
> from tab1
> where
> 10>some(col1, col2);
>
>
> reg Kai
Received on Thu Nov 11 1999 - 04:10:55 CST