Write a query to delete duplicate records in SQL SERVER
Answer Posted / skumar
Hi friends, please just try out this. This works fine for me.
We have lot of methods to do this. But using temp table,
drop the original table,retain the temp as orinial is not a
good pratice.
When u have large no of data it will affect ur performance.
DELETE FROM employee WHERE((SELECT eid,COUNT(eid) FROM
employee GROUP BY eid) > 1)
Is This Answer Correct ? | 15 Yes | 46 No |
Post New Answer View All Answers
What is the datatype of rowid?
Ways to improve the performance of a SQL Azure Database?
how you can configure a running aggregate in SSRS?
Explain “row_number()” in sql server with an example?
How to change the password of a login name in ms sql server?
What are different types of subquery?
What are the components of dbms?
What is the difference between char, varchar and nvarchar?
Write an sql query for deleting duplicate rows?
What are the rendering extensions of ssrs?
What is a group function explain with an example?
How do I schedule a sql server profiler trace?
How use inner join in sql server?
What is a non-clustered index?
What is difference between delete & truncate commands?