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
5731 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 will you do windows authentication and what is the namespace?

0 Answers

difference between Response.write,server.transfer and also which one is used when ?

0 Answers

What is Com Callable wrapper?when it will created?

0 Answers

Explain about continuable exceptions?

0 Answers

Can you explain update progress control?

0 Answers

WHAT IS COMPUTER

7 Answers NICE, TVS,

So what exactly is the configuration file for then?

0 Answers

Which tool you will use to deploy a windows service

1 Answers Fulcrum Logic,

How can i create only one instance of class and thus doesn't allow creating any more instances?

1 Answers

what is a tool tip

2 Answers Six Sigma,

What is the use of delegates

2 Answers

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

0 Answers

For more Dot Net AllOther Interview Questions Click Here