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

To create a localized application which namespaces are necessary?

0 Answers   Siebel,


Is overriding of a function possible in the same class?

0 Answers  


How do you implement multiple inheritance in .NET?

5 Answers   Infosys, Microsoft,


Does C# supports multi-dimensional arrays?

3 Answers   Microsoft,


What Are The .Net Object

2 Answers   Reliance, IMB,






What is a satellite assembly in c#?

0 Answers  


In gridview in editmode if we want to display information in one combobox based on

0 Answers   Microsoft, FD,


What do you mean by synchronous and asynchronous operations?

0 Answers  


Difference between direct type casting and using "as" keyword?

1 Answers   TCS,


How to print labels in windows form in C# .net

5 Answers  


What are the collection classes ?

2 Answers   Digital GlobalSoft,


What is method overriding in c#

0 Answers  






Categories