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
5567 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 are the events for a form?

0 Answers Six Sigma,

How to call .NET Web service from Java Appl. & Why ?

1 Answers

Can you give an example of what might be best suited to place in the Application_Start and Session_Start subroutines?

2 Answers

What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture

0 Answers

Difference between throw exception and rethrowing ?

0 Answers

.net platform independent or dependent?

5 Answers TCS,

What re interop services?

0 Answers

What is this DLL hell problem in dotnet? Can a virtual class be created/can a virtual method be created inside the class?

3 Answers HCL,

How can we perform data binding in atlas?

0 Answers

6. Wcf- what is SOA

0 Answers PCS,

Whate are resource files? How are they used in .net?

0 Answers

How do I write to the application configuration file at runtime?

0 Answers

For more Dot Net AllOther Interview Questions Click Here