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

What is icomparer in c#?

894

how to print invert pyramid in c#

1719

Why generics are used?

857

Define multicast c# delegate?

917

How does one compare strings in c#?

966

What is the main method?

887

Why do we use polymorphism in c#?

845

What is difference between throw and throws in c#?

827

Is c# pass by reference?

851

What are the different types of assemblies available and their purpose?

872

Why is c# a good programming language?

935

Is object an int c#?

866

What is a deadlock lock?

892

What is pure abstract class in c#?

862

How do you prevent a method from being overridden in c#?

816