DELETE FROM tableName WHERE id NOT IN (SELECT MIN(id) FROM tableName GROU

1) how to delete duplicate records from table in sql server
2005

2) what is run time polymorphism

Question Posted / reva

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

Please Help Members By Posting Answers For Below Questions

What is the difference between Java and .NET garbage collectors?

505

What is the difference between parse and tryparse in c#?

488

What is a di class?

527

How do you inherit a class into other class in c#?

480

Can you access a hidden base class method in the derived class?

496

What are the drawbacks of extending an interface as opposed to extending a class?

466

What is a must for multitasking

563

Why do we use threads in c#?

510

can you allow a class to be inherited, but prevent the method from being over-ridden?

548

Is typeof c#?

532

What are the 2 types of data types available in c#?

493

Are value types sealed?

511

Do events have return type c#?

504

Is lazy thread safe c#?

503

What do you know about WM_CHAR message?

569