SqlConnection con = Tools.Baglanti; SqlDataAdapter adapt = new SqlDataAdapter("WITH CTE (Name,SurName,Tckn,Email, DuplicateCount) AS ( SELECT Name, SurName, Tckn, Email, ROW_NUMBER() OVER(PARTITION BY Name, SurName, Tckn, Email ORDER BY Id) AS DuplicateCount FROM Employees ) DELETE FROM CTE WHERE DuplicateCount > 1", con);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)