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

4 Answers
9117 Views
HCL, IBM, L&T, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is escape sequence in c#?

1003

How we convert private assembly into public assembly?

953

Name the control which cannot be placed in mdi?

883

What is the difference between a function and a method?

974

What is a Assembly?

945

What happens when thread sleep () method is called?

899

What is the file extension for c#?

1031

What is jit? What are the different types of jit?

1008

What does dbml mean?

867

What is hash c#?

951

Is as keyword in c#?

869

Why do we use interfaces in c#?

937

What is int parse in c#?

979

Can you call from an inherited constructor to a specific base constructor if both base class and an inheriting class has a number of overloaded constructors?

954

What is an assembly in dotnet?

987