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
- 4 Answers
- 8989 Views
- HCL, IBM, L&T, I also Faced
- E-Mail Answers
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 |
Explain the differences between static, void and public in c#?
What are the uses of namespaces?
Can we declare class as protected?
What is the difference between a variable and a literal?
What’s thread.sleep() in threading ?
Is array thread safe c#?
Diff b/w casting and boxing
What is attribute c#?
What is the object class in c#?
How many bytes is an int in c#?
Why do we use delegates in c#?
what is IComparable
-
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)
