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
Why is it efficient to use System.string under System.Text.StringBuilder ?
Can a class or a struct have multiple constructors?
Explain About web methods and its various attributes
What are the Types of assemblies that can be created in dotnet
What is tryparse c#?
What is the c# equivalent of c++ catch (...), Which was a catch-all statement for any possible exception?
What is the difference between a function and a method?
Is null in c#?
What is arraylist class in c#?
What is using in c#?
What is toint32 c#?
What is a factory in c#?
Is ram a heap?
Why generics are used in c#?
What is the difference between interface and inheritance in c#?