Write a query to delete duplicate records in SQL SERVER

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / durga prasad

36 Answers
76408 Views
Infosys, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Write a query to delete duplicate records in SQL SERVER..

Answer / dharmesh

your table look like this and want to delete duplicate
record

chandran 23
ranjith 24
chandran 23

delete top(1) from tablename where name='chandran' and
age=23

Is This Answer Correct ?

3 Yes

28 No

Write a query to delete duplicate records in SQL SERVER..

Answer / sonia

Create table info(comp_id int identity(101,1),comp_name
varchar(50))
insert into info values('Progressive Ltd.')
insert into info values('Progressive Ltd.')
insert into info values('EliResearch')
insert into info values('Patni')
insert into info values('Accenture')
insert into info values('Accenture')
select * from info

DELETE FROM info
WHERE comp_name IN
(SELECT comp_name FROM info
GROUP BY comp_name HAVING COUNT(comp_name) > 1)

Is This Answer Correct ?

12 Yes

38 No

Write a query to delete duplicate records in SQL SERVER..

Answer / anil

delete from tab_nam where

Is This Answer Correct ?

2 Yes

30 No

Write a query to delete duplicate records in SQL SERVER..

Answer / 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

Write a query to delete duplicate records in SQL SERVER..

Answer / chandran.s

Table Name: Example

Name Age
chandran 23
ranjith 24
chandran 23

To delete one of the duplicate records use following query

delete from example where age in(select age from example
group by age having count>1)

Is This Answer Correct ?

13 Yes

46 No

Write a query to delete duplicate records in SQL SERVER..

Answer / chandran

There is a table like this: tablename: example

Name Age
chandran 23
ranjith 24
chandran 23

In this table the name:chandran and age:23 are the
duplicate records .so we need to delete this using this
sql statements

delete from example group by name,age having count>1

Is This Answer Correct ?

37 Yes

107 No

Post New Answer