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
- 51944 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 a primary key? : Sql dba
Which one is better subquery or joins?
How to know the last executed procedure?
What makes a good primary key?
Are subqueries better than joins?
How do I run a pl sql procedure in sql developer?
how mysql optimizes distinct? : Sql dba
Is left join same as inner join?
How do you explain an index?
What is transaction control language (tcl)?
What is difference between inner join and self join?
What is identity column in sql server?
What is the use of sqldataadapter?
Why do we use procedures in sql?
What is union?
