SELECT ProductName FROM Products WHERE (ProductName IN (SELECT ProductNa

How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table?

Question Posted / rajesh kumar patnaik

29 Answers
51053 Views
Alps, Aricent, Bank Of America, Wipro, I also Faced
E-Mail Answers

Answer Posted / rajesh kumar patnaik

SELECT ProductName
FROM Products
WHERE (ProductName IN
(SELECT ProductName
FROM Products
GROUP BY ProductName
HAVING COUNT(*) > 1))

Is This Answer Correct ?

8 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are sql data types?

971

How do I run a sql trace?

923

What are the types of triggers in sql?

1041

Is sql harder than python?

1053

What are aggregate functions in sql?

1110

Does group by remove duplicates?

995

How do I upgrade sql?

968

State few characteristics of pl/sql?

942

explain advantages of myisam over innodb? : Sql dba

1030

What does sql stand for?

958

What is the difference between having clause and where clause?

1028

What are the topics in pl sql?

946

What is oracle and pl sql?

1096

Can procedure in package be overloaded?

1042

Is clustered index a primary key?

903