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

4 Answers
8954 Views
HCL, IBM, L&T, I also Faced
E-Mail Answers

Answer Posted / nkm

SELECT col1,col2 FROM tDupData
GROUP BY col1,col2
HAVING COUNT(*) > 1

Is This Answer Correct ?

4 Yes

14 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the function of .IsDescendent()?

978

What is the difference between yield and return?

827

State the top.NET class that everything is derived from?

885

Explain data types in c#?

886

What is a virtual property. Give an example?

888

Which is faster dictionary or list?

867

What is difference between a constant and read-only in C#?

912

What is a private class in c#?

1023

How to move to a state-related codebase?

1473

What is default access modifier for class in c#?

942

What is the data type for bit in c#?

887

How does c# generics and c++ templates compare?

862

User's session is explicitly killed by which method ?

895

What is the predicate of a sentence?

865

if a base class has a number of overloaded constructors, and an inheriting class has a number of overloaded constructors; can you enforce a call from an inherited constructor to a specific base constructor?

985