Finding duplicate rows in a table

From: 131W10000-JamesonJ <jameson_at_coupler.drink-eid>
Date: Tue, 12 Jul 1994 21:56:42 GMT
Message-ID: <CsuKyI.8qy_at_bigtop.dr.att.com>

There are several tables in our database that contain duplicate records. Isn't there some simple SQL code to locate duplicate rows in a table? I would really appreciate it if you could post a sample.

Thanks,

Jeremy Jameson Received on Tue Jul 12 1994 - 23:56:42 CEST

This message: [ Message body ]
Next message: Tim Wendt: "SQL*Loader POSITION clause question"
Previous message: Michael Sallwasser: "Datamation's Proposed Extention to SQL Language (#1)"
Next in thread: Kim Medlin: "Max size of PL/SQL procedure"
Reply: Oddmund Johannessen: "Re: Finding duplicate rows in a table"
Reply: Teresa A Larson: "Re: Finding duplicate rows in a table"
Reply: Kim Medlin: "Max size of PL/SQL procedure"
Maybe reply: Edward Dansker: "Re: Finding duplicate rows in a table"

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

Original text of this message