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
51648 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

What is cursor and why it is required?

1176

Are subqueries better than joins?

963

What are the steps for performance tuning.

1326

What does rownum mean in sql?

1017

is it possible to pass an object or table to a procedure as an argument?

1120

How to install oracle sql developer?

1038

What is dba in sql? : SQL DBA

1034

What are tables in sql?

1052

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

1034

What is sql partition?

1097

What is thread join () in threading?

1003

What are the different types of triggers?

1128

What is difference between inner join and self join?

1077

How bulk collect improves performance?

995

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1054