Xref: alice comp.databases.oracle.misc:19714
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!Cabal.CESspool!bofh.vszbr.cz!newsgate.cistron.nl!het.net!pascal.a2000.nl!not-for-mail
From: "Arjan van Bentem" <avbentem@DONT-YOU-DAREdds.nl>
Newsgroups: comp.databases.oracle.misc
Subject: Re: identical columns
Date: Wed, 9 Sep 1998 21:50:39 +0200
Organization: -
Lines: 16
Message-ID: <6t6m43$lg2$1@newton.a2000.nl>
References: <01bddbfd$5f3ec540$a049100a@pc743-sode.seurope.ikea.com>
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0

>I have the following problem: I have a table of which I know that it
>contains duplicate rows. I want to find all rows that are duplicate.


    select name, count(*)
    from emp
    group by name
    having count(*) > 1;

If you need to delete the duplicate rows, then search for quite recent posts
in these newsgroups.

Arjan.