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 unmannaged code and will CLR handle this kind of code or not .
Why do we need indexers in c#?
Is typeof c#?
What is the difference between int.Parse() and Convert.toInt32().
What is action in c# 3.5?
What is difference between method overriding and method overloading?
What is escape sequence in c#?
How do you set a class path?
How did you implemented classes in your project?
What Happens In Memory When You Box And Unbox A Value-type?
Is null empty or whitespace c#?
Can u create multiple threads of execution ?
1 Answers IBM, ITC Infotech, UHU,
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)