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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: MINUS--Sql help

RE: MINUS--Sql help

From: Kevin Lange <kgel_at_ppoone.com>
Date: Fri, 13 Jul 2001 07:56:39 -0700
Message-ID: <F001.00349CBD.20010713070527@fatcity.com>

The MINUS operation is prety straight forward.

The result set from query 1 is compared to the result set of query 2 and any records that exist in both are removed.

With this in mind, if your first query and your second query result sets have NO RECORDS IN COMMON then you will ONLY get the records from your first queries result set.

Kevin

-----Original Message-----
Sent: Thursday, July 12, 2001 5:47 PM
To: Multiple recipients of list ORACLE-L

I am writing a SQL query using the MINUS operator.Both the select statements return a number result and I
am trying to get the o/p with the difference of both the queries using the MINUS
between the two select statements.But I am getting the o/p of the first query only
and the displayed result is not the subtracted value.Both select statements give
different number o/p when run individually.What could be wrong.

Is there anything that i am missing to consider when using the MINUS operator.

Pls help

Thanks
Ravindra

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ravindra Basavaraja
  INET: ravindra_at_sentica.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
  INET: kgel_at_ppoone.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Fri Jul 13 2001 - 09:56:39 CDT

Original text of this message

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