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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
