Re: Q: select query - Mailing list pgsql-sql

> in other words, all but the first row of a group.

Interesting question. The below should work and be quick so long as
there is a UNIQUE(col1, col2) constraint.

SELECT col1    , col2 FROM jWHERE col2 != (SELECT col2                 FROM j AS jsub                WHERE col1 =
j.col1            ORDER BY col2 ASC                LIMIT 1);