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 can you do as a .net developer?

951

What is the difference between int16 and int32 in c#?

944

What is strong name assembly?

883

Is Multiple-inheritance supported by c#?

994

What is string concatenation?

997

Is null in c#?

886

Is c# code is managed or unmanaged code?

1047

What is global namespace in c#?

982

how to implement a web service in .net

985

What is the difference between internal and protected in c#?

1022

Why generics are used?

909

What is response redirect in c#?

906

What is attribute and reflection in c#?

1007

What do you mean by a windows process in regards to memory allocation?

965

Define parsing? Explain how to parse a datetime string?

972