Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Selecting Duplicates ???

Selecting Duplicates ???

From: Richard Elliott <bullseye_at_flash.net>
Date: Fri, 09 Apr 1999 01:48:17 GMT
Message-ID: <370D5BF7.E5722B0A@flash.net>


I thought I had a simple request the other day, turned out I couldn't do it with a select, had to write a small pl/sql block. I needed to select a list of duplicates in a single table. I thought "minus" would do it but not so ! I looked in every source of SQL/Oracle documentation I have ( a lot !) and no mention of how to identify duplicates. I know the key of a table can be used to keep duplicates from existing but these are duplicates based on other columns.
Anybody have the answer ? I like to solve these request with SQL selects if possible because I can give the SQL to the user and he can run it himself using ODBC if he needs to later. Received on Thu Apr 08 1999 - 20:48:17 CDT

Original text of this message

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