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
- 50687 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
how to present a past time in hours, minutes and seconds? : Sql dba
What are sql triggers used for?
What is scope and visibility in PL/SQL?
What is dynamic query?
Is truncate ddl or dml?
what is the difference between delete and truncate commands? : Sql dba
How does rowid help in running a query faster?
What is sqlservr exe?
How to check if a column is nullable before setting to nullable?
What are the different types of a subquery?
What do you mean by field in sql?
What are schema-level triggers?
Can we use delete in merge statement?
How do I view a sql trace file?
What is the difference between the implicit and explicit cursors?
