From: | "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com> |
---|---|
To: | Oliveiros d'Azevedo Cristina <oliveiros(dot)cristina(at)marktest(dot)pt> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Lowest 2 items per |
Date: | 2012-06-01 16:35:53 |
Message-ID: | AF7D9319B29A0242A33C3BF843BD31330EFB8DA1@USA7061MS03.na.xerox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> -----Original Message-----
> From: Oliveiros d'Azevedo Cristina
[mailto:oliveiros(dot)cristina(at)marktest(dot)pt]
> Sent: Friday, June 01, 2012 12:28 PM
> To: Relyea, Mike
> Cc: pgsql-sql(at)postgresql(dot)org
> Subject: Re: [SQL] Lowest 2 items per
>
> Yes, you are right, now, thinking about the way I built it, the query,
indeed,
> leaves out the corner case of models which have just one consumable.
>
> I didn't try ur version of the query.
> Does itork now with your improvements ?
> Or were they only gramatical ?
>
> Best,
> Oliver
I only made grammatical changes necessary for the query to function
(adding a missing FROM, fully qualifying "SELECT Make" as " SELECT
subquery2.Make", etc.)
I tried changing the join type to right and left but that did not have
the desired result.
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Oliveiros d'Azevedo Cristina | 2012-06-01 16:58:54 | Re: Lowest 2 items per |
Previous Message | Oliveiros d'Azevedo Cristina | 2012-06-01 16:28:01 | Re: Lowest 2 items per |