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
- 51908 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / amit
select * from taruntest1 b where rowid not in (select min
(rowid) from taruntest1 a where a.a=b.a );
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What is a full join?
What is sql clause?
What is integrity in sql?
What is package in pl sql?
How to know the last executed procedure?
Does mysql support pl sql?
What is compute?
How many sql core licenses do I need?
How can one get sql*loader to commit only at the end of the load file? : aql loader
Can you call pl/sql package functions from within a fast formula?
Can we use update in sql function?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is clustered index sql?
Does a user_objects view have an entry for a trigger?
can a stored procedure call itself or recursive stored procedure? : Sql dba
