Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL - SOME - ANY

SQL - SOME - ANY

From: Kai Sodemann <Kai.Sodemann_at_memo.ikea.com>
Date: 3 Aug 1999 09:00:32 GMT
Message-ID: <01bedd8e$dea67ce0$6e49100a@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 Tue Aug 03 1999 - 04:00:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US