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 type cast in C#?
0 Answers TryTechnicals Pvt Ltd,
How do you type a null character?
Why do we need escape characters?
Explain the process of abstraction with an example?
How do you implement multiple inheritance in .NET?
What is hashtable c#?
Why do we need collections in c#?
When a Static Constructor is called in a Class?
What are cshtml files?
How many aware interfaces are there?
How to achieve polymorphism in c#?
What is the Use Of Interfaces? For example I have a interface as shown below? Interface IMyInterface { public void MyMethod(); } class MyClass : IMyInterface { public void Mymethod() { Some Code } } class Program { static void Main(string[] args) { MyClass obj = new MyClass(); obj.MyMethod(); } } Here What is My Question is? If i remove Interface and run this code, it will executed then what is the Use of the interface? Can any one give me the solution for this Problem? Thanks in Advance!
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)