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 floating point types is supported in C#?
How you will connect to windows directory in c#?
2 Answers HP, nTech Solutions,
What are Regex / regular expressions ?
What is the console on a mac?
Why do we need abstract class?
What is out int in c#?
What are the Uses of CLR
Can we have 2 main methods in c#?
How to use exception handling in stored procedure?
What is lazy loading and eager loading in c#?
What framework is used for performance testing/load testing?
Explain manifest & metadata?