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 marshalling and what are different kinds of marshalling?

970

What are "class access modifiers" in C#?

1012

How long can loop recorders stay in?

1228

What is iqueryable?

1006

Is c# code is unmanaged or managed code?

1168

How do you comment in c#?

1037

What types of object can I throw as exceptions?

979

Is it possible to have different access modifiers on the get/set methods of a property in c#?

1038

What does the dispose method do with the connection object?

1020

Explain the difference between a Private Assembly and a Shared Assembly

1025

What is Custom attribute? How to create? If I'm having custom attribute in an assembly, how to say that name in the code?

986

Are there constructors in c sharp?

1015

What is the use of functional interface?

973

Explain inheritance in c#?

1000

What are c# collections?

946