Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.1/8.9.1) with ESMTP id NAA11307 for ; Thu, 3 Dec 1998 13:58:38 -0500 (EST) (envelope-from sferac@bo.nettuno.it) Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by trends.net (8.8.8/8.8.8) with ESMTP id CAA27112 for ; Thu, 3 Dec 1998 02:45:00 -0500 (EST) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id IAA21416; Thu, 3 Dec 1998 08:44:52 +0100 (MET) Received: from blu.sferacarta.com (mail.sferacarta.com) [10.20.30.12] by proxy.sferacarta.com with smtp (Exim 2.05 #1 (Debian)) id 0zlGnj-0003bP-00; Wed, 2 Dec 1998 18:14:59 +0000 Date: Wed, 2 Dec 1998 17:23:11 +0100 From: Sferacarta Software X-Mailer: The Bat! (v1.017) UNREG Reply-To: Sferacarta Software Organization: Sferacarta Software Priority: Normal Message-ID: <18724.981202@bo.nettuno.it> To: pgsql-sql@postgresql.org, Mario Filipe Subject: Re: [SQL] Query to eliminate duplicates References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit MF> Is there a way to eliminate duplicate records using just SQL? SELECT DISTINCT ... -Jose'-