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
- 50969 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 do you understand by pl/sql cursors?
How do you optimize a stored procedure query?
What are the types of join and explain each?
What is the purpose of my sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
what is log shipping? : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is the difference between the conventional and direct path loads? : aql loader
Can you select everything, but 1 or 2 fields, without writer's cramp?
How do I partition in sql?
What are secondary keys?
what are the nonstandard string types? : Sql dba
How to add, remove, modify users using sql?
What are the two types of cursors in pl sql?
What is sqlca in powerbuilder?
