Path: utzoo!attcan!uunet!tut.cis.ohio-state.edu!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!think!ames!uhccux!larned
From: larned@uhccux.uhcc.hawaii.edu (Paul Larned)
Newsgroups: comp.databases
Subject: SQL query for duplicates
Keywords: SQL, ORACLE
Message-ID: <5784@uhccux.uhcc.hawaii.edu>
Date: 21 Dec 89 19:52:58 GMT
Organization: University of Hawaii
Lines: 11

I am starting an application in Oracle v.5.1b Prof. for MS-DOS for a
network of PCs which will use RDBMS v.6 for OS/2--this after years of
writing applications in a dBASE environment.  I am importing a fixed-
column data file from a UNIFY database into an ORACLE-created table.
The primary key field I want to use has several duplicates in it from
an unprotected UNIFY environment.  I am having trouble writing a SQL
statement to identify the duplicate 4-digit numbers (in a character
field) in the new database so that they can be changed or deleted.  I
hope I am not reduced to listing all rows and visually identifying the
duplicates.  There are about 1000 rows.  I would appreciate any
suggestions.