Re: Identifying duplicate rows

From: <jieyuan_at_my-deja.com>
Date: Wed, 02 Feb 2000 22:03:45 GMT
Message-ID: <87a9jr$49q$1@nnrp1.deja.com>

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

In article <87a0qm$t0q$1_at_nnrp1.deja.com>, milesr_at_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. Received on Wed Feb 02 2000 - 16:03:45 CST