select your_number, count(*) from your_table
group by your_number
having count(*) > 1
milesr_at_my-deja.com wrote in message <87a0qm$t0q$1_at_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.
Received on Wed Feb 02 2000 - 14:08:54 CST
