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 |
What is inumerable?
How do destructors and garbage collection work in c#?
List down the different ide’s provided by microsoft for c# development.
Explain 'structure padding'?
What?s the implicit name of the parameter that gets passed into the class? set method?
What is typeof c#?
an object,class is value type or refarance type. ?
How do I type a whitespace character?
Explain About Iunknown interface Queue
How to find methods of a assembly file (not using ILDASM)?
Explain the difference between a namespace and assembly name in .net?
What is the role of the datareader class in ado.net connections?