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



1) how to delete duplicate records from table in sql server 2005 2) what is run time polymorphi..

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

1) how to delete duplicate records from table in sql server 2005 2) what is run time polymorphi..

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

1) how to delete duplicate records from table in sql server 2005 2) what is run time polymorphi..

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




1) how to delete duplicate records from table in sql server 2005 2) what is run time polymorphi..

Answer / nkm

SELECT col1,col2 FROM tDupData
GROUP BY col1,col2
HAVING COUNT(*) > 1

Is This Answer Correct ?    4 Yes 14 No

Post New Answer



More C Sharp Interview Questions

What is the difference between readonly and constant in c#

2 Answers   Fulcrum Logic,


what is a enumeration in c#

0 Answers   Cognizant,


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?

0 Answers   HCL,


What does Dispose method do with the connection object?

2 Answers  


How to make sure custom class supports deterministic finalization?

1 Answers   IBM,






Why do we use Design Pattern?

1 Answers   Impetus,


What namespaces are necessary to create a localized application?

1 Answers  


What are the collection classes ?

2 Answers   Digital GlobalSoft,


Explain About multi level and multiple inheritance how to achieve in .net

0 Answers  


What is ControlBox Propertie

0 Answers   MCN Solutions,


Where is the output of TextWriterTraceListener redirected?

1 Answers  


use of operator overloading of implicit & explicit operators?

1 Answers   TCS,






Categories