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
- 51644 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 get help information from the server? : Sql dba
What are two statement types in sql?
What is sqlservr exe?
What are the benefits of stored procedures?
What is the advantage of nosql?
What is sql basics?
How many sql databases can you have on one server?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
How do you optimize a query?
what are the different tables present in mysql? : Sql dba
What is the difference between unique and primary key constraints?
Name the different types of indexes in sql and define them.
Will truncate release space?
What is the non-clustered index in sql?
Why do we need sharding?
