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
What are the different parts of a package?
what is the difference between truncate and drop statements? : Sql dba
Why do we use function in pl sql?
how can we optimize or increase the speed of a mysql select query? : Sql dba
How do I write a sql query in pgadmin 4?
what is a composite primary key ? : Sql dba
what's the difference between a primary key and a unique key? : Sql dba
How many indexes can be created on a table in sql?
What are tables in sql?
Why triggers are used?
What is view explain with example?
Can you join a table to itself?
What is cross join example?
what is the difference between $message and $$message? : Sql dba
What is a procedure in pl sql?