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 is difference between float and integer?

981

What is difference between dictionary and hashtable in c#?

866

Is it possible to have a static indexer in c#? Allowed in c#.

945

What is the usage of Enumeration in C# Programming and is it good to use or not ?

973

Why singleton is sealed?

855

What is escape character in c#?

910

What is the difference between CONST and READONLY?

1067

Explain the difference between const and static read-only?

991

What's the difference between the debug class and trace class? Documentation looks the same.

1081

What is int32?

897

Define satellite Assembly in .NET?

981

What is the difference between ref & out parameters in c#?

943

What does do in c#?

976

What tool we have to use to install assembli in gac folder.

899

List the 5 different access modifiers in c#?

918