with cte (c1, c2, rr) as ( select c1, c2, row_number() over(partition by c1,c2 order by c1,c2)[rr] from tbl1 ) delete from cte where rr>1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)