Using "SOME" in a subselect
From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Thu, 18 Dec 2008 10:12:10 -0700
Message-ID: <3c5f7820812180912m4839f4c0o592425f8dbfc35aa@mail.gmail.com>
Date: Thu, 18 Dec 2008 10:12:10 -0700
Message-ID: <3c5f7820812180912m4839f4c0o592425f8dbfc35aa@mail.gmail.com>
I came across some code today that has the following:
SELECT
.
.
.
WHERE
.
.
.
AND p.refreshTimeStamp = SOME
(SELECT MAX(pa.refreshTimeStamp) FROM pymt pa WHERE compid = '12345666'
Can anyone tell me what the " = SOME" portion of the code does? I've done some research, but can't find anything so far.
-- Sandy Transzap, Inc. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 18 2008 - 11:12:10 CST