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

can any one send the project manager questions in .net

1 Answers  


What is difference between int and int32 in c#?

1 Answers  


What happens if the inherited interfaces have conflicting method names?

0 Answers  


List the two important objects of ado.net and also list the namespaces that are commonly used in ado.net to aid in connection to a database.

0 Answers  


What is literal control

0 Answers  


Explain the types of Polymorphism.

0 Answers   Accenture,


In a C# class we have a SortedList member m_addinProjects we want to provide an iterator to allow the consumer of this class access to the items in the collection. Please provide an iterator method for the AnalyzeAddinsDLL class below and an example of how it would be used. namespace AnalyzeAddinsDLL { public class AllAddInProjects { private SortedList<string, AddInProject> m_addinProjects; public AllAddInProjects() { m_addinProjects = new SortedList<string, AddInProject>(); } } }

0 Answers   ABC, WinsIndia,


What are object pooling and connection pooling and difference between them?

0 Answers  


Define clr in .net?

0 Answers  


What is the ouput of the following program?

0 Answers  


Any .net training centers available near hitech city , hyderabad?

2 Answers  


what are some characteristics of an array?

0 Answers  


Categories