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
5738 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 COM with example?

0 Answers MaxSolPro,

data types used in validation control

0 Answers PCS,

What is the use of TPL DATAFLOW?

0 Answers MCN Solutions,

where should I put this information then?

0 Answers

So what exactly is the configuration file for then?

0 Answers

Explain the types of memory management? : .NET Architecture

0 Answers

What's new in the .net 2.0 class library?

0 Answers

What is WPF and WCF?

0 Answers Infosys,

Tell me .net mobile emulators? : Microsoft dot net mobile

0 Answers

what is class and object explain with example?

8 Answers Six Sigma,

which would be the best to use inproc,outproc or sql server

2 Answers Ness Technologies,

What is .net mobile utility controls. Explain with an example? : Microsoft dot net mobile

0 Answers

For more Dot Net AllOther Interview Questions Click Here