Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Silly SQL Question
The original question was "show me the users who have ALL the values in the list but NOT MORE than the values in the list."
> -----Original Message-----
> Bellow, Bambi
>
> Huh? I thought the question was, "give me all the usrs where
> there exists a
> record containing a 1,5, and 7". How can that return one
> record, when there
> are two users -- and only two users -- who have the 1,5,7
> combination? The
> data provided shows that both GAP and GPA have a 1, 5 and 7
> and that no
> other users do. My query provides that answer. If that wasn't the
> question, then that won't be the answer; but if it *was* the
> question, then
> the query is correct.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: Jacques.Kilchoer_at_quest.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Nov 17 2003 - 13:19:26 CST