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 / mohan

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

Answer Posted / mohan

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

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to drop an existing index in mysql? : Sql dba

1069

how can you see all indexes defined for a table? : Sql dba

1000

what is a constraint? : Sql dba

1173

What is an oracle stored procedure?

1053

What is varray in pl sql?

1076

Which is faster truncate or drop?

1045

What is dynamic sql in pl sql?

1036

what are the difference between clustered and a non-clustered index? : Sql dba

1033

what are the 'mysql' command line options? : Sql dba

1073

What is identity column in sql server?

1049

what is a database lock ? : Sql dba

1173

Can ddl statements be used in pl/sql?

1145

What do you think about pl/sql?

1034

How do I find duplicates in a single column in sql?

1020

what are rollup and cube in t-sql? : Transact sql

1100