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
- 51845 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
Why is pl sql used?
What view means?
What is right join sql?
What version is sql?
How do I sort a table in sql?
Which data type is a composite type?
What is localdb mssqllocaldb?
What are the different types of dbmss?
What are the various restrictions imposed on view in terms of dml?
What are the types of sql commands?
What is Difference Between Unique and Primary Key Constraints?
Is a foreign key always unique?
What is serial sql?
What is database migration?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
