select count(*),column_name from table_name group by 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 / kalaiselvan.j

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

Answer Posted / kalaiselvan.j

select count(*),column_name from table_name group by
column_name having count(*)>1

Is This Answer Correct ?

14 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is native sql query?

1076

how can we repair a mysql table? : Sql dba

1043

Why do we need cursors in pl sql?

1157

What is program debugging?

1342

What is the difference between numeric and autonumber?

1038

What is information schema in sql?

1115

What is the use of sql trace?

1003

what is the different between now() and current_date()? : Sql dba

1075

What is pivot in sql?

973

what is log shipping? : Sql dba

1165

What is hibernate and its relation to sql?

1171

Why do we use subquery?

1076

What is character functions?

1114

What is an intersect?

1156

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

1075