SELECT * FROM TAB1 A WHERE A.ROWID > ANY (SELECT B.ROWID FROM TAB2 WHER

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?

Question Posted / dev

29 Answers
51647 Views
Alps, Aricent, Bank Of America, Wipro, I also Faced
E-Mail Answers

Answer Posted / dev

SELECT * FROM TAB1 A WHERE A.ROWID > ANY
(SELECT B.ROWID FROM TAB2 WHERE A.COL1=B.COL1)

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is left join inner or outer by default?

1014

Why partition by is used in sql?

1028

What is full join in sql?

982

what are numeric data types? : Sql dba

1056

Which one is better subquery or joins?

1052

What is example of database?

1049

List the different type of joins?

1057

How do you determine the current isolation level? : Transact sql

1146

what is bdb (berkeleydb)? : Sql dba

1022

what is a unique key ? : Sql dba

1082

What is the largest value that can be stored in a byte data field?

1008

what is data integrity? : Sql dba

1026

How do I view an execution plan in sql?

975

discuss about myisam index statistics collection. : Sql dba

941

Why do we need sharding?

982