PostgreSQL Select command that will list only duplicate rows

From: Khangelani Gama <Khangelani(dot)Gama(at)ucs-software(dot)co(dot)za>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL Select command that will list only duplicate rows
Date: 2010-11-10 08:06:30
Message-ID: D78A8169F9436B4DB978300336168F3B407DAB5FFD@SWBREXCH00.ucs-software.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all

I am looking for a PostgreSQL Select command that will list me only duplicate rows.

I am using psql 8.4.4.10

Thanks in advance

Confidentiality Notice:http://ucs.co.za/conf.html

________________________________
The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential information of UCS Group and/or its subsidiaries. Any review, use or dissemination thereof by anyone other than the intended addressee is prohibited. If you are not the intended addressee please notify the writer immediately and destroy the e-mail. UCS Group Limited and its subsidiaries distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Viktor Bojović 2010-11-10 08:56:56 Re: PostgreSQL Select command that will list only duplicate rows
Previous Message Tena Sakai 2010-11-10 02:32:28 Re: I want to find out who is using a database