Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2004
    Posts
    50

    Arrow Unanswered: How to delete duplicate records in a table

    Hi
    Can you please suggest a query to delete duplicate records from a table such that only one record of each type is maintained in table, and its duplicate entries are deleted.

    Thanx
    Ishan

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    This question has been asked and answered MANY times.
    It appears you are too lazy to even do a search of this forum
    before posting your question.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    yes, shame on you.
    we "Grand Poobah's" have better things to do
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Are the Grand Poobah's a little "testy" today ???? Just because it's Friday .... You guys need to understand that having to search the forum could require some considerable time and effort ... that may EVEN cause the homework assignment to be late ...

  5. #5
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Say u have a table A with column as col1 number which contains value as 1 in multiple rows, u intend to have only one row with value as 1 then issue the following


    delete from A where rowid<(select max(rowid) from col1 where col1=1);

    I gave an easy example to demonstrate , frame up the sql statement to meet ur needs. Use rowid..

    Cheers

    Kaushik

  6. #6
    Join Date
    Nov 2003
    Location
    India
    Posts
    114

    Re: How to delete duplicate records in a table

    It seems Isha has made some mistake by posting her question on this forum .

    Kaushik 's reply was best. He encouraged lady to go for answer giving some hints.

    But Grand Poobahs Plz avoid words like "Shame on You " . This really makes peoples feel bad.

  7. #7
    Join Date
    Jan 2004
    Posts
    153
    I do agree with VARUN and strongly protest the words "Shame on you..."

Posting Permissions

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