From: | Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org> |
---|---|
To: | LH <_pgsql-novice_(at)geekhouse(dot)no-ip(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: order by, but eliminating dupes |
Date: | 2003-09-04 06:12:43 |
Message-ID: | CBB65ED2-DE9E-11D7-B534-000393C78AC0@visualdistortion.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Something like this works:
select a,b,c from t1 group by a,b,c order by min(q)
Jeff
On Wednesday, September 3, 2003, at 09:52 PM, LH wrote:
> So lets say I got a table A(x,y,z, Q) ordered by column Q, with
> contents
> like so:
>
> x y z Q
> ------------------------
> 21 5 x 1
> 21 5 x 2
> 43 10 t 3
> 1 2 a 5
> 43 10 t 10
> 21 5 x 50
>
> what I would like is to take the results of this query, and maintaining
> the order, only list x, y, z , AND
> not list any duplicates.
>
> So the result I'd want after getting this query would be:
>
> x y z
> ----------------
> 21 5 x
> 43 10 t
> 1 2 a
>
> So I'm pulling the results as they come along, and ignore any
> subsequent
> dupes.
>
> I don't know if this is even possible. I've tried combinations of
> SELECT
> DISTINCT, GROUP BY, and others
> with
> no luck. The best I could do was to do the order by in a subquery, then
> do a SELECT UNIQUE on the subquery.
> But that kills the order of the subquery. I've tried group by x,y,z but
> then I can't ORDER BY Q.
>
> - L
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Jeffrey Melloy | 2003-09-04 06:15:15 | Re: Errors on restoring a 7.1.2 dump to 7.3.3 |
Previous Message | Aarni Ruuhimäki | 2003-09-04 06:06:48 | Re: Modyifying a column's datatype |