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 a clr host?

1011

What is difference between === and ==?

942

What is the difference between string and stringbuilder in c#?

1026

Is dll a library?

972

What type of data type conversion happens when the compiler encounters the following code?

992

What are interfaces in c#?

1011

List down the different ide’s provided by microsoft for c# development.

935

What is the difference between namespace and class?

1010

What is writeline in c#?

921

Is it good to use var in c#?

912

explain Garbage collectorâ€™s functionality on unmanaged code

980

Describe two uses of the “using” statement during the operation of c#?

1001

Is null or empty in c#?

1009

Can a struct have a default constructor (a constructor without parameters) or a destructor in c#?

1020

What is uint16?

968