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
51673 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 the difference between a procedure and a function?

1098

How to read/write files from pl/sql?

1031

What are pl/sql cursors?

1045

Which command is used to delete a trigger?

1321

Explain polymorphism in pl/sql.

1110

What is sql exception?

957

what is rdbms? : Sql dba

1008

What do you think about pl/sql?

1016

What are different types of tables in sql?

990

What is sql query optimization?

1103

Define SQL and state the differences between SQL and other conventional programming Languages?

1204

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1121

does sql support programming? : Sql dba

1033

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1100

What is query execution plan in sql?

1177