SELECT col1,col2 FROM tDupData GROUP BY col1,col2 HAVING COUNT(*)

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

2) what is run time polymorphism

Question Posted / nkm

Answer Posted / nkm

SELECT col1,col2 FROM tDupData
GROUP BY col1,col2
HAVING COUNT(*) > 1

Is This Answer Correct ?

4 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What do you mean by saying a "class is a reference type"?

695

What are the three types of predicates?

626

How to implement an object pool in c#.net.

785

What is ado c#?

718

What you mean by delegate in c#?

668

What is difference between throw and throws in c#?

629

Can we customize the serialization process?

706

What is sqlcommandbuilder c#?

622

How is method overriding different from overloading?

759

What is the usage of transponders?

715

What is multicast delegate explain with example?

656

Is there an equivalent of exit() for quitting a c# .net application?

717

Explain About namespaces

762

Define a partial class?

664

What is public void in c#?

712