delete dup rows in oracle

Discussion in 'Oracle' started by Kannan S, Mar 28, 2010.

  1. Kannan S

    Kannan S New Member

    Joined:
    Mar 28, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Chennai(India)
    hi...dudes...
    can anyone post the simplest ans for deleting duplicate rows in oracle....
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
  3. sudhagar

    sudhagar New Member

    Joined:
    Apr 6, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Software Engineer
    Location:
    Chennai
    try this one n let me know.. it will delete duplicate row from the table..


    delete from employee t1 where exists(
    select * from employee t2 where t2.name=t1.name and
    t2.sa=t1.sa and t2.rowid>t1.rowid);
     
  4. PRASOON

    PRASOON New Member

    Joined:
    Jun 4, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Ya this is working dude
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice