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

What is the purpose of Accordian in jquery? Where it can be used?

0 Answers

Explain some of the disadvantages due to microsoft.net?

0 Answers

Navigation controls in ASP.net,explain each control in brief?

2 Answers Six Sigma,

What is a virtual memory? : Dot net architecture

0 Answers

How can implement drag and drop using atlas?

0 Answers

Please tell me the .net 2.5 frame work with example

2 Answers

what is polymorphism and advantage ?

0 Answers TCS,

Explain the use of virtual, sealed, override, and abstract.

0 Answers

What is .net mobile images control. Explain with an example? : Microsoft dot net mobile

0 Answers

State and explain about microsoft.net?

0 Answers

What does this do? Gacutil /l | find /i "corillian"

0 Answers

how to delete the record using data reader

0 Answers PCS,

For more Dot Net AllOther Interview Questions Click Here