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
- 50889 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 sql*loader?
i have some prob lem to tell me about my self in interview first round ...
How do I clear the screen in sql plus?
what is sql in mysql? : Sql dba
What are the set operators in sql?
how to fetch alternate records from a table? : Sql dba
What is a database? Explain
What is memory optimized?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
Explain ddl statements in pl/sql?
What is trigger in sql and its types?
Which one is faster ienumerable or iqueryable?
What is the difference between inner join and left join?
How delete all data from table in sql?
explain the difference between bool, tinyint and bit. : Sql dba
