clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 630115 fiddles created (11377 in the last week).

create table t (Rownumber int,OldIdassigned varchar(100),commoncode varchar(100));
 hidden batch(es)


insert into t values(1,'FLEX','Y2573F102'), (2,'RCL','Y2573F102'),(3,'FLEX','Y2573F102'), (4,'QGEN','N72482123'),(5,'QGEN','N72482123'), (6,'QGEN','N72482123'),(7,'RACE','N72482123'), (8,'CLB','N22717107'),(9,'CLB','N22717107'), (10,'CLB','N22717107')
10 rows affected
 hidden batch(es)


delete t2 from (select t1.*, row_number() over(partition by commoncode order by Rownumber) rn from t t1 )t2 where rn<>1 ;
7 rows affected
 hidden batch(es)


select * from t
Rownumber OldIdassigned commoncode
1 FLEX Y2573F102
4 QGEN N72482123
8 CLB N22717107
 hidden batch(es)