Results 1 to 6 of 6
  1. #1
    Join Date
    May 2010
    Posts
    52

    Unanswered: deleting duplicate rows in a table

    i have a table and i am trying to delete duplicate rows and keep one record. i have 2 columns are am lookinf at to tell me that the data is duplicated. i want to delete the one of the records and keep the other. help... no unique key and its 2000
    Last edited by mosdef; 04-19-11 at 15:16.

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    You may create a stored procedure to accomplish it.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    Sep 2010
    Posts
    153

    Smile example

    Sloution with an example would be better

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by sunny_007 View Post
    Sloution with an example would be better
    table layouts with comprehensive data would be best
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    select distinct into new table then rename the tables

  6. #6
    Join Date
    Mar 2008
    Posts
    40

Posting Permissions

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