1) how to delete duplicate records from table in sql server
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 the difference between readonly and constant in c#
what is a enumeration in c#
In languages without exception-handling facilities, we could send an error-handling procedure as a parameter to each procedure that can detect errors that must be handled. What disadvantages are there to this method?
What does Dispose method do with the connection object?
How to make sure custom class supports deterministic finalization?
Why do we use Design Pattern?
What namespaces are necessary to create a localized application?
What are the collection classes ?
Explain About multi level and multiple inheritance how to achieve in .net
What is ControlBox Propertie
Where is the output of TextWriterTraceListener redirected?
use of operator overloading of implicit & explicit operators?