There are many ways to do that but most probably it would be much round trip , here is the simple way of removing the duplicates.
insert into santest values (1,'A')
insert into santest values (1,'A')
insert into santest values (1,'A')
insert into santest values (2,'B')
insert into santest values (2,'B')
insert into santest values (3,'C')
insert into santest values (3,'C')
WITH tbl_del AS (
SELECT *,ROW_NUMBER () OVER (
PARTITION BY id,name ORDER BY id ) AS Rnum
FROM santest)
DELETE FROM tbl_del WHERE Rnum > 1
