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: pstnotpd <schoenmakers_at_tpd.tno.nl>
Date: Mon, 30 Aug 2004 09:55:42 +0200
Message-ID: <cgumgf$440$1@voyager.news.surf.net>


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 - 02:55:42 CDT

Original text of this message

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