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’s a strong name?

527

Which are the loop types available in c#?

497

What is the implicit name of the parameter that gets passed into the class set method?

494

How does it work?

513

What is the difference between dispose() and finalize() methods in c#?

511

What is eager and lazy loading in c#?

470

Can a struct have a default constructor (a constructor without parameters) or a destructor in c#?

522

What is different about switch statements in c#?

492

Distinguish between the Debug class and Trace class with its functionality?

535

What is the difference between internal and private in c#?

511

How many types of serialization are there in c#?

461

List down the fundamental oop concepts?

503

List the difference between the virtual method and the abstract method?

495

What is cookies in c# asp net?

514

Define an assembly in .net?

529