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 string data types? : Sql dba
What is the difference between left outer join and left join?
What is left join in sql?
What is sql performance tuning?
What is trigger point?
What are some predefined exceptions in pl/sql?
How to select all records from the table?
define data blocks ? : Sql dba
What is the difference between inner join and left join?
What is sql comments?
Can we use ddl commands in pl sql?
What is clustered index in sql?
Write a query to find the names of users that begin with "um" in sql?
What is record data type?
What is sqlexception in java?