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

Where test director stores its data ? Database ,Local file etc...? I need to read this data from Visual Studio 2005 c# client. Regards

1824

What is eager loading in c#?

852

Can the accessibility of a type member be greater than the accessibility of its containing type?

903

How can we sort an array in c#?

860

What are delegates?

1184

Is c# a keyword?

888

Why we use anonymous methods in c#?

897

What is use of a HashTable in .NET?

1106

How would you describe encapsulation in c#?

855

What are cookies in c#?

915

What is boxing in c#?

929

What is using directive in c#?

992

What is an actual parameter?

892

is it possible to access a remote web service Without UDDI?

966

In a site to turn off cookies for one page which method is followed?

901