select distinct * from Mytable select distinct * into Newtable from Mytabl

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

2) what is run time polymorphism

Question Posted / kishore

Answer Posted / kishore

select distinct * from Mytable
select distinct * into Newtable from Mytable
drop table Mytable
select * into Mytable from Newtable

Is This Answer Correct ?

12 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between the system.array.copyto() and system.array.clone()?

881

What is the difference between list and arraylist c#?

963

Why abstract class is not instantiated in c#?

893

Explain the feature of c# language?

852

What is func c#?

948

What does addressof operator do in background ?

958

What is the best dependency injection c#?

832

What is a Command Object in C#?

976

What is the advantage of generics in c#?

858

Can abstract class have constructor c#?

815

What are generations and how are they used by the garbage collector?

874

Can you use foreach iteration on arrays in c#?

1012

What is difference between for and foreach loop in c#?

946

what is IComparable

944

What is the difference between ienumerable and enumerable?

851