2 Replies Latest reply: Feb 14, 2013 1:49 AM by 711584 RSS

    How to delete single row from multiple

    711584
      Hi:l


      This is my query which provides duplicate rows in my table:

      select count(*),CUSTMAST_REQUEST_SRNO,ACTIVITYMAST_SRNO,STATUSMAST_SRNO from REQUEST_TRANS having count(*)>1 group by CUSTMAST_REQUEST_SRNO,ACTIVITYMAST_SRNO,STATUSMAST_SRNO;


      O/p:

      2 |M984 | 74 |M6
      2 |M985 | 74 |M6
      2 |M987 | 74 |M6
      2 |M992 | 74 |M6
      2 |M995 | 74 |M6
      2 |M998 | 74 |M6

      Here output shows that CUSTMAST_REQUEST_SRNO M984 having two same rows. And now i want
      to delete any one of row from that. So, how can i apply it for multiple rows ?

      Can any body help-out me in that?

      Thank You,
      Anup Desai

      Edited by: user11688398 on Feb 13, 2013 10:39 PM