How to delete the duplicate records in a table using sql server

How to delete the duplicate records in a table using sql
server

Question Posted / thiru_moon

4 Answers
5423 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to delete the duplicate records in a table using sql server..

Answer / mohamed idhris

SET ROWCOUNT 1

DELETE FROM tbl_name WHERE field_name= 'field_value'

SET ROWCOUNT 0

the above query will delete the duplicate row

Is This Answer Correct ?

4 Yes

2 No

How to delete the duplicate records in a table using sql server..

Answer / rakesh pattajoshi

delete from tbl where id not in(select max(id) from tbl group by name)

Is This Answer Correct ?

0 Yes

0 No

How to delete the duplicate records in a table using sql server..

Answer / priya

use distinct.it removes the duplicate rows

Is This Answer Correct ?

0 Yes

0 No

How to delete the duplicate records in a table using sql server..

Answer / ranjitha

Add Primary Key to the table.

Is This Answer Correct ?

2 Yes

9 No

Post New Answer

More Dot Net AllOther Interview Questions

how to find the 2nd higgest salary in the column for example take table name is employee? And also find bottom 2nd lowest salary ?

11 Answers GeoTechnology, Wipro,

Explain difference between state server and sqlserver? : .NET Architecture

0 Answers

what is a namespace?how they are classified?write a program which contains class,object,inheritance?

0 Answers Six Sigma,

How to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile

0 Answers

Explain .net mobile events? : Microsoft dot net mobile

0 Answers

server.transfer limitation ?

0 Answers

how u maintain data while navigating one page to another?

2 Answers

Wcf- What is ABC

1 Answers PCS,

What is the use of TPL DATAFLOW?

0 Answers MCN Solutions,

What re interop services?

0 Answers

What is the access level of the visibility type internal?

0 Answers

What is a clickonce application?

0 Answers

For more Dot Net AllOther Interview Questions Click Here