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?
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 are tables in sql?
What does fetching a cursor do?
Can we join two tables without common column?
What is a recursive join sql?
What is oracle sql developer?
What is a nested table in word?
What are the constraints available in sql?
Can we use rowid as primary key?
Explain some predefined exceptions.
How many scalar data types are supported in pl/sql?
Can a foreign key be a duplicate?
what are date and time data types? : Sql dba
Does truncate remove indexes?
What is the need of a partition key?
What is sqlerrd?