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 difference between throw and throws in c#?

869

List out two different types of errors in c#?

923

Which namespace is required to implement trace ?

978

Why do we need abstraction in c#?

927

What is managed or unmanaged code?

1067

Explain the constructor in c#.

1109

What is JIT (just in time)? how it works?

1005

What is use of private class in c#?

988

Is c# and c same?

893

How much time will it take to learn unity?

936

What is the concept of strong names?

984

Give an example of removing an element from the queue?

937

What are value types in c#?

899

how to implement a web service in .net

976

What is monitor in C#?

1015