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

Home -> Community -> Usenet -> comp.databases.theory -> Re: How to do a difference on two sets from same table?

Re: How to do a difference on two sets from same table?

From: Dan <dan_at_nospam.com>
Date: Mon, 30 Aug 2004 11:42:06 -0500
Message-ID: <uNIYc.27$5p3.18307@news.uswest.net>


I don't know what you mean. Could someone give me the complete SQL?

TIA,
Dan

On 8/30/2004 2:55 AM, pstnotpd wrote:

> Have a look at MINUS
> 
> 
> Dan wrote:
> 

>> Hi,
>>
>> Say I have a sales history table that has the following fields:
>> custid, invoicedate, prodid, quantity, cost, sale. And that I want to
>> select sales records where invoicedate is between 5/1/04 and 8/31/04
>> and where these are new sales for each customer, meaning that the
>> customer did not buy the prodid in the period 1/1/04 to 4/30/04. I
>> know conceptually that this is a difference between two sets based on
>> custid+prodid but I don't know how to express this in SQL. Please help.
>>
>> TIA,
>> Dan
Received on Mon Aug 30 2004 - 11:42:06 CDT

Original text of this message

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