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
- 51183 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
Can you inner join the same table?
How many types of sql are there?
What are the different sql languages?
What is a system versioned table?
Does mysql support pl sql?
What is the use of non clustered index?
what is cursor. write example of it. What are the attributes of cursor.
what is transaction? : Sql dba
What is trigger in pl sql?
What is compiled query?
What is a unique constraint?
Does oracle use sql?
What are the types of join and explain each?
What is sql in java?
What are the types pl/sql code blocks?
