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 unmannaged code and will CLR handle this kind of code or not .

0 Answers   DELL,


Why do we need indexers in c#?

0 Answers  


Is typeof c#?

0 Answers  


What is the difference between int.Parse() and Convert.toInt32().

2 Answers  


What is action in c# 3.5?

0 Answers  


What is difference between method overriding and method overloading?

0 Answers  


What is escape sequence in c#?

0 Answers  


How do you set a class path?

0 Answers  


How did you implemented classes in your project?

1 Answers   TCS,


What Happens In Memory When You Box And Unbox A Value-type?

0 Answers   Siebel Systems,


Is null empty or whitespace c#?

0 Answers  


Can u create multiple threads of execution ?

1 Answers   IBM, ITC Infotech, UHU,


Categories