1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,285
    Likes Received:
    364
    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