Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 use of delegate?

0 Answers  


You are designing a user control. You created new property called backgroundimage which is of type image. You wanted to disable storing this property in the user’s form. How to achieve this?

0 Answers  


Can derived classes have greater accessibility than their base types?

0 Answers  


explain the three services model commonly know as a three-tier application.

0 Answers   Siebel Systems,


what is c# command?

0 Answers  


How to make sure custom class supports deterministic finalization?

1 Answers   IBM,


Why do we override in c#?

0 Answers  


Is array reference type / value type?

15 Answers   Accenture,


What is deadlock in c#?

0 Answers  


What is the difference between IEnumerator and IEnumerable?

0 Answers   QuestPond,


Explain what a diffgram, and a good use for one Define diffgram? How it be used?

0 Answers   Siebel,


Why do we use static methods in c#?

0 Answers  


Categories