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?
- 28 Answers
- 47269 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / seshu
SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY
RNO,NAME having Count(*)>1;
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is primary key in db?
How do I make sql search faster?
How many sql databases can you have on one server?
Does pl sql work in mysql?
What is pl sql architecture?
Which certification is best for sql?
explain what is mysql? : Sql dba
Does sql backup shrink transaction log?
What does subquery mean in sql?
What is rowid in sql?
How to test for null values?
How do I remove sql developer from windows 10?
What is rank dense_rank and partition in sql?
What are secondary keys?
Is not equal in sql?
