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?
- 28 Answers
- 47328 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
What is number function in sql?
Why is a trigger used?
What is the use of & in pl sql?
what is auto increment? : Sql dba
How can get second highest salary in sql?
what are the differences between require and include, include_once and require_once? : Sql dba
How do I run a sql script?
How to run sql statements with oracle sql developer?
What do you understand by pl/sql packages?
Which is better join or subquery?
how many ways we can we find the current date using mysql? : Sql dba
Can sql developer connect to db2?
Why do we use sql constraints?
Which table is left in left join?
How many types of triggers are there in pl sql?
