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
50689 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

What is the left table in sql?

914

how to get @@error and @@rowcount at the same time? : Sql dba

968

Is join and inner join the same?

940

what is the difference difference between procedure and packages

10250

What is sql deadlock?

1048

How many types of primary keys are there?

977

Explain the purpose of %type and %rowtype data types with the example?

925

What is the use of sqldataadapter?

907

What are local and global variables and their differences?

1045

What does truncate mean in sql?

961

what is rollback? : Sql dba

1022

What is the purpose of my sql?

900

Explain the savepoint statement.

1038

What are some predefined exceptions in pl/sql?

1063

What is db journal file?

956