On 12 Sep 2003 10:58:45 -0700, [EMAIL PROTECTED] (G. Ralph Kuntz, MD) wrote:
>I would like to select the second and subsequent rows where the first
>column is the same:
>
> 1 b
> 1 c
> 3 f
>
>in other words, all but the first row of a group.
all = SELECT * FROM t;
but = EXCEPT
the first row of a group =
SELECT i, min(x) FROM t GROUP BY i;
or (if there are more columns)
SELECT DISTINCT ON(i) * FROM t ORDER BY i, x;
Putting it together:
SELECT i, x FROM t EXCEPT (SELECT i, min(x) FROM t GROUP BY i);
or
SELECT * FROM t EXCEPT (SELECT DISTINCT ON(i) ...);
Servus
Manfred
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
