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
- 50727 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 are pl sql procedures?
How many joins can you have in sql?
What are different types of tables in sql?
What is left join example?
What are few of the schema objects that are created using PL/SQL?
What are the packages in pl sql?
what is clause? : Sql dba
What is sql clause?
What are the differences between in and exists clause?
What are the advantages of stored procedure?
Do ddl statements need commit?
Does sql*plus also have a pl/sql engine?
How many types of tables are there?
What is sqlexception in java?
Inline the values in PL/SQL, what does it mean.?
