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?

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 are the different parts of a package?

856


what is the difference between truncate and drop statements? : Sql dba

793


Why do we use function in pl sql?

820


how can we optimize or increase the speed of a mysql select query? : Sql dba

734


How do I write a sql query in pgadmin 4?

756


what is a composite primary key ? : Sql dba

830


what's the difference between a primary key and a unique key? : Sql dba

751


How many indexes can be created on a table in sql?

726


What are tables in sql?

787


Why triggers are used?

790


What is view explain with example?

725


Can you join a table to itself?

754


What is cross join example?

776


what is the difference between $message and $$message? : Sql dba

784


What is a procedure in pl sql?

841