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

Explain the access modifiers in c#?

484

What is sqldatareader c#?

480

How to override a function in c#?

534

What is the difference between method overriding and method overloading?

470

Is cli same as the clr?

513

What is overloading in c#?

470

Is a structure a class?

490

Describe the ways of cleaning up objects in c#.

512

What is the difference between protected and private?

457

What is static class in C#?

559

Is c# scripting language?

497

What is hashtable in c# with example?

488

What do u mean by thread safe?

486

What is default c#?

493

How can you write a class to restrict that only one object of this class can be created (Singleton class)?

514