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
- 51847 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kumargvk
select * from education a where rownum>(select max(rownum)
from education b where b.rno=b.rno)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between subquery and correlated query?
What is a primary key? Explain
What are the events on which a database trigger can be based?
Why do we use sql constraints?
what is the difference between delete and truncate commands? : Sql dba
What operating systems are supported by oracle sql developer?
how do you know if your mysql server is alive? : Sql dba
Can we create index on primary key?
What is data abstraction in sql?
What are the different types of a subquery?
Can dml statements be used in pl/sql?
How many tables can a sql database have?
What is data type in database?
Explain the steps needed to create the scheduled job?
What are user defined functions?
