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
- 51951 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 a table partition?
How do we use distinct statement? What is its use?
What are secondary keys?
explain normalization concept? : Sql dba
How do you know if a relationship is 2nf?
What does an inner join do?
How do you respond to dementia behavior?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Does sap use sql?
How to start the command-line sql*plus?
What is minus?
What are the various levels of constraints?
How many primary keys can a table have?
What are sql ddl commands?
What is varchar used for?
