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
5582 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

Explain .net mobile events? : Microsoft dot net mobile

0 Answers

Explain pipelining? : Dot net architecture

0 Answers

12. Types of polymorphisem[Run and Design Exp.]

0 Answers PCS,

what is meant by language interoperability and language integration?

1 Answers Six Sigma,

Explain the process of gc?

0 Answers

Explain the difference between l1 and l2 cache? : .NET Architecture

0 Answers

any one can explain about projectarchitecture and project approach briefly

0 Answers

what is an assembly ?

2 Answers IBM,

How does .net remoting work?

0 Answers

Explain cache memory? : .NET Architecture

0 Answers

which control is used to compare two controls?

1 Answers

So what exactly is the configuration file for then?

0 Answers

For more Dot Net AllOther Interview Questions Click Here