Re: COPY from .csv File and Remove Duplicates - Mailing list pgsql-general

On Fri, 12 Aug 2011, David Johnston wrote:

> Select *
> From table
> Natural Inner join (
> SELECT loc_name, sample_date, param, Count(*) as duplicate_count
> FROM table
> Group by loc_name, sample_date, param
> ) grouped
> Where duplicate_count > 1
> ;

David,

   Thank you. I was close in my attempts, but not sufficiently close. This
works.

Much appreciated,

Rich