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
- 52616 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 difference between stored function and application function?
how can we destroy the cookie? : Sql dba
What is data types in sql?
What is the purpose of using pl/sql?
What is the difference between unique and primary key constraints?
What is a procedure in pl sql?
What is case function?
What is the difference between jpql and sql?
What are the types pl/sql code blocks?
How many scalar data types are supported in pl/sql?
What is minus?
How do you explain an index?
Is sql harder than python?
What are the different types of dbmss?
What is the use of non clustered index?
