Xref: alice comp.databases.oracle.server:83105
From: "Jeff Hunter" <jeffh@btitelecom.net>
Newsgroups: comp.databases.oracle.server
References: <87a0qm$t0q$1@nnrp1.deja.com>
Subject: Re: Identifying duplicate rows
Date: Wed, 2 Feb 2000 15:08:54 -0500
Lines: 51
X-Newsreader: Microsoft Outlook Express 4.72.2120.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2120.0
Message-ID: <38988efd@defiant.btitelecom.net>
X-Trace: 2 Feb 2000 15:09:33 -0500, webpool.btitele.com
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!hermes.visi.com!news-out.visi.com!uunet!ffx.uu.net!defiant.btitelecom.net!webpool.btitele.com

select your_number, count(*) from your_table
group by your_number
having count(*) > 1

milesr@my-deja.com wrote in message <87a0qm$t0q$1@nnrp1.deja.com>...
>Hi all,
>
> I'm trying to develop the PL/SQL code that can list only numbers that
>are duplicates, for example:
>
> NUMBER
>  12
>  12
>  13
>  14
>  15
>  16
>  16
>  16
>  16
>  17
>  18
>  19
>  20
>  21
>  22
>  23
>  24
>  24
>  24
>  24
>  24
>
> The desired output should look like this:
>
>NUMBER
>  12
>  16
>  24
>
>
>Any help would be appreciated.
>
>
>Ronald
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.