1) how to delete duplicate records from table in sql server
2005
2) what is run time polymorphism
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shailesh
2>Polymorphism is done by two way Overloading and
overriding.Overriding is called the runtime Polymorphism.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / reva
DELETE FROM tableName WHERE id NOT IN
(SELECT MIN(id) FROM tableName GROUP BY name)
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / nkm
SELECT col1,col2 FROM tDupData
GROUP BY col1,col2
HAVING COUNT(*) > 1
Is This Answer Correct ? | 4 Yes | 14 No |
Does c# support #define for defining global constants?
Is static thread safe?
Why do we need interfaces in c#?
How would you describe encapsulation in c#?
Is there an equivalent to the instanceof operator in visual j++?
Explain data types in c#?
What does do in c#?
Why do we use yield in c#?
What is the raise event used for?
Is int a struct in c#?
what is uniary operators and binary operators and what is the difference
Can You Prevent Your Class From Being Inherited By Another Class?