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 meant by clr?

949

What are the benefits of using generics?

917

Is string null or empty?

852

What's c# ?

938

What is serializable in c#?

859

What is a decimal in c#?

901

What is thread safe in c#?

836

What is a dbml?

847

What is default method in c#?

954

Why c# is type safe?

876

How are methods overloaded?

946

Give an example to show for hiding base class methods?

804

What are the differences between system.string and system.text.stringbuilder classes?

939

Why do we parse in c#?

822

How do you specify a custom attribute for the entire assembly?

885