Re: Q: select query

On 12 Sep 2003 10:58:45 -0700, grk(at)usa(dot)net (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