create table demo11 (dn int, rn varchar(max))
insert into demo11 values(1,'A'),(1,'A-1'),(1,'A-3'),(2,'A'),(2,'B'),(2,'C')
-------------
|dn |rn |
-------------
|1 |A |
|1 |A-1|
|1 |A-3|
|2 |A |
|2 |B |
|2 |C |
-------------
Expected Result : delete (1 A, 1 A-1, 2 A, 2 B) result 1 A-3, 2 C
rows which are to be delted :1,2,4,5
