Re: PostgreSQL Select command that will list only duplicate rows

select rowName,count(1)
from table
group by rowName
having count(1)>1

On Wed, Nov 10, 2010 at 9:06 AM, Khangelani Gama <
Khangelani(dot)Gama(at)ucs-software(dot)co(dot)za> wrote:

> 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.
>

--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me