Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    9

    Lightbulb Unanswered: Deleting duplicate rows from a table, having no primary key

    I am looking at various methods to delete records from a table which has duplicate records and does not have a foriegn key, in a single query.

    One of the methods is using the rowid.

    Looking for more.
    Visheetal
    Last edited by visheetal; 04-27-04 at 17:07. Reason: I am just looking for sql solutions, not PL/SQL

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    That would be the easiest.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •