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
- 50994 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
Can you skip header records while loading? : aql loader
what are null values? : Sql dba
What is sql rowcount?
What are the qualities of 2nf?
Can we use rowid as primary key?
What is the difference between left outer join and left join?
Why is nosql good?
What are the topics in pl sql?
what are all the different normalizations? : Sql dba
What is a scalar value in sql?
Can unique keys be null?
What is pls_integer in pl sql?
What is sqlite used for?
what are aggregate and scalar functions? : Sql dba
Is pl sql better than sql?
