Re: Identifying duplicate rows

Hi , Ronald,

You can simply run a query ( Or Cursor ) like this:

  Select number_field, count(*) duplicate_times   from your_table
  group by number_field
  having count(*) >1;

Hope this helps.

Sean Zhang
sean_at_cnfei.com

<milesr_at_my-deja.com> wrote in message news: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:33:11 CST