1) how to delete duplicate records from table in sql server
2005
2) what is run time polymorphism
Answer Posted / reva
DELETE FROM tableName WHERE id NOT IN
(SELECT MIN(id) FROM tableName GROUP BY name)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the difference between gettype and typeof in c#?
What is a Jagged Array in C#?
if a base class has a number of overloaded constructors, and an inheriting class has a number of overloaded constructors; can you enforce a call from an inherited constructor to a specific base constructor?
For methods inside the interface why can’t you specify the accessibility modifier?
What is the advantage of static class in c#?
Is array reference type in c#?
Can abstract class be instantiated c#?
What are the types of comments in c#?
Define constructors
Is static thread safe?
What is the difference between do and while loop?
How is lazy loading achieved?
Overloaded constructor will call default constructor internally?
What is the delegates in c#?
Why do we use lambda expression in c#?