Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 29 Answers
- 52621 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / aravind
select SPAN_UUID, SPAN_UNIT_UUID, count(*) from
SPAN_SPAN_UNIT group by SPAN_UUID, SPAN_UNIT_UUID having
count(*) > 1;
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Could you please provide oca (oracle 10g) dumps for my certification ?
What are the types of dbms?
How can we implement rollback or commit statement in a trigger?
Why schema is used in sql?
What is before and after trigger?
how to use 'mysql' to run sql statements? : Sql dba
What is cost in sql execution plan?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Why should I use postgresql?
What is normalisation in sql?
What is the need of a partition key?
What is nosql example?
How do you know if a relationship is 2nf?
how to rename an existing column in a table? : Sql dba
what is the use of friend function? : Sql dba
