SQL-ANY-SOME

From: Kai Sodemann <Kai.Sodemann_at_memo.ikea.com>
Date: 3 Aug 1999 12:55:39 GMT
Message-ID: <01beddaf$b72dcd00$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 Tue Aug 03 1999 - 14:55:39 CEST