Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 6EE659FB26C
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  2 Feb 2007 09:55:41 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 96908-03 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  2 Feb 2007 09:55:32 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3])
	by postgresql.org (Postfix) with ESMTP id 5AB149FB1BA
	for <pgsql-sql@postgresql.org>; Fri,  2 Feb 2007 09:55:32 -0400 (AST)
Received: from webaccess.indicator.be ([10.100.1.7]) by
	interscan.indicator.com with InterScan Message Security Suite;
	Fri, 02 Feb 2007 14:43:46 +0100
Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise;
	Fri, 02 Feb 2007 14:55:29 +0100
Message-Id: <45C350D8.A3DD.0030.0@indicator.be>
X-Mailer: Novell GroupWise Internet Agent 7.0.1 
Date: Fri, 02 Feb 2007 14:55:20 +0100
From: "Bart Degryse" <Bart.Degryse@indicator.be>
To: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>,
	<pgsql-sql@postgresql.org>
Subject: Re: Duplicate records
References: <55c095e90702020548h4c5ae5b2h405a2a33fb5b950@mail.gmail.com>
In-Reply-To: <55c095e90702020548h4c5ae5b2h405a2a33fb5b950@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=__Part7450FFD8.1__="
X-imss-version: 2.046
X-imss-result: Passed
X-imss-approveListMatch: *@indicator.be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.11 tagged_above=0 required=5 tests=AWL, BAYES_50,
	FORGED_RCVD_HELO, HTML_40_50, HTML_MESSAGE, UNPARSEABLE_RELAY
X-Spam-Level: 
X-Archive-Number: 200702/13
X-Sequence-Number: 27347

--=__Part7450FFD8.1__=
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

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/ 

--=__Part7450FFD8.1__=
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.2800.1264" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>select *</DIV>
<DIV>from mytable A, (select field1, field2, count(*) from mytable group by field1, field2 having count(*) &gt; 1) B</DIV>
<DIV>where A.field1 = B.field1 and A.field2 = B.field2<BR><BR>&gt;&gt;&gt; "Ezequias Rodrigues da Rocha" &lt;ezequias.rocha@gmail.com&gt; 2007-02-02 14:48 &gt;&gt;&gt;<BR>Hi list,<BR><BR>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.<BR><BR>Any help would be welcomed.<BR clear=all><BR>-- <BR>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Atenciosamente (Sincerely)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ezequias Rodrigues da Rocha<BR>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- <BR>A pior das democracias ainda é melhor d
 o que a melhor das ditaduras<BR>The worst of democracies is still better than the better of dictatorships<BR><A href="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/ </A></DIV></BODY></HTML>
--=__Part7450FFD8.1__=--