Subject | SOME or ANY |
---|---|
Author | Ian A. Newby |
Post date | 2003-07-02T10:10:16Z |
Hi Folks,
I was looking in the Interbase sql reference and noticed that
firebird supports SOME and ANY in the where clause, ie
select * from test where price < some (select price from components
where ...)
and
select * from test where price < any (select price from components
where ...)
Whats the difference between SOME and ANY? I've looked on the web
with no success.
Regards
Ian Newby
I was looking in the Interbase sql reference and noticed that
firebird supports SOME and ANY in the where clause, ie
select * from test where price < some (select price from components
where ...)
and
select * from test where price < any (select price from components
where ...)
Whats the difference between SOME and ANY? I've looked on the web
with no success.
Regards
Ian Newby