From: Bart Degryse <Bart.Degryse@indicator.be>
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Duplicate records
Date: Fri, 02 Feb 2007 14:55:20 +0100
Message-ID: <45C350D8.A3DD.0030.0@indicator.be> (raw)
In-Reply-To: <55c095e90702020548h4c5ae5b2h405a2a33fb5b950@mail.gmail.com>
References: <55c095e90702020548h4c5ae5b2h405a2a33fb5b950@mail.gmail.com>
select *
from mytable A, (select field1, field2, count(*) from mytable group by
field1, field2 having count(*) > 1) B
where A.field1 = B.field1 and A.field2 = B.field2
>>> "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> 2007-02-02
14:48 >>>
Hi list,
I am making some data minning and would like to know if someone tell me
how to retrieve the duplicate records based in one or two fields of my
table.
Any help would be welcomed.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of
dictatorships
http://ezequiasrocha.blogspot.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bart.Degryse@indicator.be, ezequias.rocha@gmail.com
Subject: Re: Duplicate records
In-Reply-To: <45C350D8.A3DD.0030.0@indicator.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox