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

Why is it efficient to use System.string under System.Text.StringBuilder ?

977

Can a class or a struct have multiple constructors?

961

Explain About web methods and its various attributes

976

What are the Types of assemblies that can be created in dotnet

1153

What is tryparse c#?

942

What is the c# equivalent of c++ catch (...), Which was a catch-all statement for any possible exception?

994

What is the difference between a function and a method?

974

Is null in c#?

872

What is arraylist class in c#?

1081

What is using in c#?

869

What is toint32 c#?

1036

What is a factory in c#?

872

Is ram a heap?

913

Why generics are used in c#?

957

What is the difference between interface and inheritance in c#?

893