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. Categories >> Software >> Microsoft Related >> C Sharp
  2. Suggest New Category

1) how to delete duplicate records from table in sql server
2005

2) what is run time polymorphism

Question Posted / anil

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

Explain the difference between the debug class and trace class?

0 Answers  

What is a statement c#?

0 Answers  

Which type of variables are under the control of garbage collector?

4 Answers   Kanbay,

what is read only and constant

8 Answers   FIC, IBM,

What is data binding with example?

0 Answers  

Which debugging tools you can use in the .NET ssSDK?

0 Answers   Siebel,

what is the difference between finally and dispose methods?

3 Answers   HCL, Patni,

Describe an abstract class?

0 Answers   Siebel,

What is the difference between String s(Small s) and String S(Capital S)?

4 Answers  

Write a program to create a user control with name and surname as data members and login as method and also the code to call it. (Hint use event delegates) Practical Example of Passing an Events to delegates

0 Answers  

What is variable and its classification?

0 Answers  

Are there functions in c#?

0 Answers  

For more C Sharp Interview Questions Click Here
Categories