1) how to delete duplicate records from table in sql server
2005
2) what is run time polymorphism
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 |
Post New Answer View All Answers
Explain the difference between the system.array.copyto() and system.array.clone()?
What is the difference between list and arraylist c#?
Why abstract class is not instantiated in c#?
Explain the feature of c# language?
What is func c#?
What does addressof operator do in background ?
What is the best dependency injection c#?
What is a Command Object in C#?
What is the advantage of generics in c#?
Can abstract class have constructor c#?
What are generations and how are they used by the garbage collector?
Can you use foreach iteration on arrays in c#?
What is difference between for and foreach loop in c#?
what is IComparable
What is the difference between ienumerable and enumerable?