Re: Group By?

On Feb 9, 1:08 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> On Feb 8, 2:53 pm, "shakespeare" <what..._at_xs4all.nl> wrote:
>
>
>
>
>
> > <ame..._at_iwc.net> schreef in berichtnews:1c04d8cf-f3da-4b8b-9b0d-8e451c94c762_at_h11g2000prf.googlegroups.com...
>
> > > Hi All,
>
> > > I have the following query.  For a few records, it returns duplicate
> > > CUSTOMER_ID's, though the rest of the record values are different.
>
> > > I want 1 record per CUSTOMER_ID, regardless of the other values.
>
> > >   SELECT co.customer_id c_id, engine.calc_end_date (co.order_date,
> > > p.quantity, p.quantity_uom) end_date,
> > >          DECODE(ns.subscr_type, 'Trial', 'Trial', 'Test', 'Trial',
> > > 'Paid') subscr_type
> > >   FROM engine.customer_order co, engine.order_line ol, engine.product
> > > p, product.newsletter_subscription ns
> > >   WHERE co.order_id = ol.order_id
> > >   AND ol.product_id = p.product_id
> > >   AND p.code = ns.code
> > >   AND p.subproduct_id IN (197, 202, 209, 216, 220, 222)
> > >   AND ol.status = 'Active'
> > >   ORDER BY co.customer_id;
>
> > > Still working a solution.
>
> > Then DON'T select the other values (if you don't care about them)....
>
> > Shakespeare- Hide quoted text -
>
> > - Show quoted text -
>
> Actually I do need them, as they are used later in another
> query.......

But what good are they? If you have the same customer id with different end dates and subscr_types but you only choose one of them with no regard for which one you choose how can the other columns be of any value? Received on Mon Feb 11 2008 - 08:37:10 CST