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
- 50724 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / harish
select * from education where rownum < ( select max(rownum)
from education group by <column_name> )
| Is This Answer Correct ? | 15 Yes | 24 No |
Post New Answer View All Answers
What is information schema in sql?
What are pl/sql cursor exceptions?
What is bind reference and how can it be created?
Explain what is sql?
What is trigger price?
What is an invalid partition table?
What is difference between ms sql and mysql?
Which is better trigger or stored procedure?
What's the procedure?
Is sql a backend language?
What is the difference between microsoft access and sql server?
What do you mean by table in sql?
Explain the savepoint statement.
What is query syntax?
Can %notfound return null after a fetch?
