Don Isgitt <djisgitt(at)soundenergy(dot)com> writes:
> I am trying to find rows in a table that are duplicates only in the
> sense of certain columns; i.e, not all columns are the same, and then
> for each duplicate entry, I want to retrieve one of the columns that is
> not part of the duplication criteria.
Try SELECT DISTINCT ON. There's a simple example in the SELECT
reference page (something about weather reports I think).
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2003-01-31 19:09:02|
|Subject: Re: ALTER STATISTIC and dump ? |
|Previous:||From: Tom Lane||Date: 2003-01-31 19:00:15|
|Subject: Re: Query performance PLEASE HELP |