DELETE FROM tableName WHERE id NOT IN (SELECT MIN(id) FROM tableName GROU

1) how to delete duplicate records from table in sql server
2005

2) what is run time polymorphism

Question Posted / reva

Answer Posted / reva

DELETE FROM tableName WHERE id NOT IN
(SELECT MIN(id) FROM tableName GROUP BY name)

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a long in c#?

462

Define thread?

591

What is callback in c#?

483

How do I create a multilanguage?

522

What issues can be faced while delivering code?

1484

Explain About friend and Protected friend

527

What is continue in c#?

520

How many types of constructors are there?

514

When is a class declared as a class abstract?

590

Is c# front end or back end?

515

What do you mean by shared assembly?

588

What is boxing in c#?

563

Is c# used for frontend or backend?

594

What does mean before a string in c#?

526

Define thread? Explain about multithreading?

576