select * from <table_name> where <column

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 / cesar di sanctis

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

Answer Posted / cesar di sanctis

select * from <table_name>
where <column_name> in
(select <column_name>
from <table_name>
group by <column_name>
having count(*) > 1)

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql key?

996

Is pl sql different from sql?

1001

Name three sql operations that perform a sort.

1015

What are the different types of triggers?

1137

Explain autonomous transaction.

1157

What is hibernate and its relation to sql?

1124

When is the explicit cursor used ?

1035

What is the difference between sql, mysql and sql server?

1105

what is a database transaction? : Sql dba

1186

What is a temporal data type?

1053

how do you know the version of your mysql server? : Sql dba

1004

Describe types of sql statements?

1059

What is numeric function sql?

1064

What is data manipulation language?

1189

how to increment dates by 1 in mysql? : Sql dba

978