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
- 52624 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / bhuvi
use self join and find the intersection
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is rollback? : Sql dba
How do I partition a table in sql?
What is bitemporal narrowing?
What is faster join or subquery?
Explain what is a view?
How is data stored on a disk?
What is aggregate function in sql?
What is a dynamic query?
What is transaction control language (tcl)?
How to select unique records from a table?
what are the advantages of mysql in comparison to oracle? : Sql dba
Explain the update statement in sql
explain advantages of innodb over myisam. : Sql dba
Do ddl statements need commit?
Is postgresql a server?
