DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: duplicate rows

  1. #1
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340

    duplicate rows

    How to delete duplicate records from one table.

  2. #2
    Join Date
    Jan 2007
    Posts
    231
    DELETE from < 'tablename'>
    WHERE rowid not in
    (SELECT MIN(rowid)
    FROM our_table
    GROUP BY COLUMN1(USE PRIMARY_KEY))

  3. #3
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Quote Originally Posted by ams-jamali
    DELETE from < 'tablename'>
    WHERE rowid not in
    (SELECT MIN(rowid)
    FROM our_table
    GROUP BY COLUMN1(USE PRIMARY_KEY))
    Thanks....



    Gopu
    Last edited by gopu_g; 04-17-2008 at 02:47 AM.

  4. #4
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    I f u know to do a google search, why did you post this message here?
    http://www.perf-engg.com
    A performance engineering forum

  5. #5
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Quote Originally Posted by malay_biswal
    I f u know to do a google search, why did you post this message here?
    if you know the answer post it..?
    a poster can find the answer in different ways..

  6. #6
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Code:
    if you know the answer post it..?
    a poster can find the answer in different ways..
    Oh Yeah u dumb ass...
    http://www.perf-engg.com
    A performance engineering forum

  7. #7
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Quote Originally Posted by malay_biswal
    Code:
    if you know the answer post it..?
    a poster can find the answer in different ways..
    Oh Yeah u dumb ass...
    R u a DBA....?

    we can find the answer in different ways..
    for getting the correct answer from the experts the people are posting in the forums like this.....
    why i posted the link there is may be it is helpful to somebody.. not to you...because i know you are an expert

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    whatever...
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  9. #9
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Quote Originally Posted by malay_biswal
    [CODE]

    Oh Yeah u dumb ass...

    this is not place to use these kind of languages....

  10. #10
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    Any guesses why you are having kind of verbal fights with lot of people around here since last 3-4 days. Think on it. It might get usefull for you in future.
    Rgds
    Parag

Posting Permissions

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


Click Here to Expand Forum to Full Width