Many times you can face problem of duplicate records in table.So How would you identify and delete duplicate records in a table?
For that Firstly check if table has duplicate records or not using below query.
SELECT [FirstName] FROM tblTest GROUP BY [FirstName] HAVING COUNT(*) > 1
Then Delete duplicate records.
DELETE FROM tblTest WHERE ID NOT IN (SELECT MAX(ID) FROM tblTest GROUP BY [FirstName])
Asked In: Many Interviews |