Xref: alice comp.databases.oracle.server:83135
Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!arclight.uoregon.edu!logbridge.uoregon.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: jieyuan@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Identifying duplicate rows
Date: Wed, 02 Feb 2000 22:03:45 GMT
Organization: Deja.com - Before you buy.
Lines: 52
Message-ID: <87a9jr$49q$1@nnrp1.deja.com>
References: <87a0qm$t0q$1@nnrp1.deja.com>
X-Article-Creation-Date: Wed Feb 02 22:03:45 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.0 BEIRUT, 1.0 x27.deja.com:80 (Squid/1.1.22) for client 38.151.130.227
X-MyDeja-Info: XMYDJUIDjieyuan



select distinct number group by number having count(*)>1;

In article <87a0qm$t0q$1@nnrp1.deja.com>,
  milesr@my-deja.com wrote:
> 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.
>


Sent via Deja.com http://www.deja.com/
Before you buy.