How to check duplicate save record in sql server

Question

how to check duplicate save record in sql server (eg 'John Smith' and 'John Smith') with .net

Kunal Patel · Answer

Using common table expression find duplicate value from your table and remove duplicate value from your table. Just change table name and field in this script. ---------------------------------------------------------------------------------------------------- ;WITH CTE (Name,duplicatecount) AS ( SELECT Name ,ROW_NUMBER() OVER (PARTITION BY Name ORDER BY Name ) AS duplicatecount FROM YourTable ) -- for show which field is duplicate from table SELECT * FROM CTE WHERE duplicatecount > 1 -- remove duplicate field from table -- DELETE FROM CTE WHERE duplicatecount > 1 ----------------------------------------------------------------------------------------------------

Rahul Borate · Answer

Hi Kunal nice query

Shakti Singh Dulawat · Answer

SELECT FieldName, COUNT(*), Max(FieldId) AS dupes FROM TableName GROUP BY FieldName HAVING (COUNT(*) > 1)

Dorababu Meka · Answer

Try this select t1.column_name, t1.id from table_name t1 inner join ( SELECT column_name, FROM table_name GROUP BY column_name HAVING COUNT (*) > 1 ) t2 on t1.column_name= t2 .column_name Fill the result in a dataset and do as per your need

How to check duplicate save record in sql server

Answers (4)