Path: utzoo!utgpu!jarvis.csri.toronto.edu!clyde.concordia.ca!uunet!aplcen!samsung!zaphod.mps.ohio-state.edu!tut.cis.ohio-state.edu!ucbvax!hplabs!pyramid!infmx!barrym
From: barrym@infmx.UUCP (Barry Mednick)
Newsgroups: comp.databases
Subject: Re: SQL query for duplicates
Summary: how to query for duplicates
Keywords: SQL, ORACLE
Message-ID: <2909@infmx.UUCP>
Date: 22 Dec 89 18:18:37 GMT
References: <5784@uhccux.uhcc.hawaii.edu>
Organization: Informix Software Inc., Menlo Park, CA.
Lines: 7


To find duplicates in a table,

  SELECT rowid, x.prime_key
      FROM tabname x, tabname y
         WHERE  x.prime_key = y.prime_key
           AND  x.rowid NOT = y.rowid