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

Can a class have more than 1 destructor?

979

What is a constructor in c#?

1294

What is the namespace for the thread class?

903

What is sqlcommand in c#?

862

What is a variable in c#?

868

What is the difference between User controls and Custom Controls?

1030

What is a thread c#?

873

What is args c#?

907

What is type checking in c#?

868

Is cli same as the clr?

858

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

962

Can an array be null c#?

905

What is an enumerator c#?

889

How do you sort a list in c#?

817

Which namespaces are necessary to create a localized application?

1027