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
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 |
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 |
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 |
Answer / nkm
SELECT col1,col2 FROM tDupData
GROUP BY col1,col2
HAVING COUNT(*) > 1
| Is This Answer Correct ? | 4 Yes | 14 No |
What is the difference between protected and internal in c#?
Define Virtual folder?
write a C# Program add two matrix ?
Name any three ways to pass parameters to a method in c#?
Can destructors have access modifiers?
About multi level and multiple inheritance how to achieve in .net ?
what is bubbled event ? give suitable example in code vice with demo
Explain the difference between private and shared assembly?
What is datasource c#?
What are satellite assemblies? How will you get the different language strings?
What is delegate in c# interview questions?
what is the diference between casting and converting?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)