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
- 51695 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
Write a sql query to convert all character to uppercase after hypen.
What is update query?
What is difference between hql and native sql?
Which one is better subquery or joins?
what does the t-sql command ident_incr does? : Transact sql
What is a sql instance vs database?
What is replication id?
Why do we create stored procedures & functions in pl/sql and how are they different?
How to take user input in pl sql?
What is denormalization in a database?
What is the maximum rows in csv?
What are the different dcl commands in sql?
How long will it take to learn pl sql?
How would you reference column values before and after you have inserted and deleted triggers?
Explain what is a column in a table?
