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?
Answer Posted / bhuvi
use self join and find the intersection
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is left join faster than inner join?
How do I sort a table in sql?
Why we use pl sql?
How do you remove duplicates without using distinct in sql?
What is pivot in sql?
What is primary key sql?
Which join is default?
What is a natural join sql?
Is primary key clustered or nonclustered?
Differentiate between syntax and runtime errors.
Is subquery faster than join?
What is a unique constraint?
How do I run a pl sql procedure in sql developer?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Why is sql*loader direct path so fast?