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
- 51646 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
What is rowtype?
What is a schema? How is it useful in sql servers?
Why use subqueries instead of joins?
Can we use joins in subquery?
What is dbo in sql?
What is pl sql commands?
What is difference between mysql and postgresql?
how can we destroy the cookie? : Sql dba
What is trigger explain it?
How is data stored in sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
How does stored procedure reduce network traffic?
what is the difference between group by and order by in sql? : Sql dba
What is varray in pl sql?
Why do we need databases?
