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 inumerable?

0 Answers  


How do destructors and garbage collection work in c#?

0 Answers  


List down the different ide’s provided by microsoft for c# development.

0 Answers  


Explain 'structure padding'?

0 Answers   DELL,


What?s the implicit name of the parameter that gets passed into the class? set method?

1 Answers  






What is typeof c#?

0 Answers  


an object,class is value type or refarance type. ?

4 Answers   Synechron,


How do I type a whitespace character?

0 Answers  


Explain About Iunknown interface Queue

0 Answers   DELL,


How to find methods of a assembly file (not using ILDASM)?

0 Answers  


Explain the difference between a namespace and assembly name in .net?

0 Answers  


What is the role of the datareader class in ado.net connections?

0 Answers  


Categories