Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: How To List Duplicate Records ?..

Re: How To List Duplicate Records ?..

From: Helmut Hahn <helmut.hahn_at_bitoek.uni-bayreuth.de>
Date: Wed, 07 Jul 1999 08:15:37 +0200
Message-ID: <3782F089.90DA0E16@bitoek.uni-bayreuth.de>

Try
select CUST_NUM,CUST_ID from CUSTOMER group by CUST_NUM having count(*) > 1;
This shows all cust_nums with more than one cust_id!

Helmut Received on Wed Jul 07 1999 - 01:15:37 CDT

This message: [ Message body ]
Next message: roguedood_at_my-deja.com: "Re: Pros vs Cons of 'With Admin Option'"
Previous message: Frank Bauer: "Re: Linking Access tables from Oracle"
In reply to: Angelica Veron: "How To List Duplicate Records ?.."
Next in thread: Alexander Romanov: "Re: How To List Duplicate Records ?.."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US