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


Please Help Members By Posting Answers For Below Questions

Is there regular expression (regex) support available to c# developers?

516


Is dictionary a collection?

464


What is the default modifier for class in c#?

504


What is use of FormBoarderStyle Propertie

528


What is difference between assembly and dll?

472






Distinguish between a class and struct?

496


Are c# generics the same as c++ templates?

490


What is an arraylist in c#?

592


How we can create an array with non-default values?

499


What do constructors do in c#?

503


Explain the features of an abstract class in net.

492


What is the difference between mobile application and desktop application?

442


Can a dictionary have the same key?

491


Name which controls do not have events?

545


What is a hash table in c#?

501