This discussion is archived
2 Replies Latest reply: Feb 13, 2013 11:49 PM by 711584 RSS

How to delete single row from multiple

711584 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points