Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Selecting Duplicates ???
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
![]() |
![]() |