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
Is there regular expression (regex) support available to c# developers?
Is dictionary a collection?
What is the default modifier for class in c#?
What is use of FormBoarderStyle Propertie
What is difference between assembly and dll?
Distinguish between a class and struct?
Are c# generics the same as c++ templates?
What is an arraylist in c#?
How we can create an array with non-default values?
What do constructors do in c#?
Explain the features of an abstract class in net.
What is the difference between mobile application and desktop application?
Can a dictionary have the same key?
Name which controls do not have events?
What is a hash table in c#?