SELECT * FROM EDUCATION E1 WHERE ROWID>(SELECT MIN(ROWID) FROM EDUCATI

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 / satheesh

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

Answer Posted / satheesh

SELECT * FROM EDUCATION E1 WHERE ROWID>(SELECT MIN(ROWID)
FROM EDUCATION E2 WHERE E1.EMPID=E2.EMPID)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql integrity?

1161

What are keys in sql?

1000

What is pl sql script?

1035

How do I run sql?

1187

Can we edit a view in sql?

983

Who developed sql?

1048

How can get second highest salary in sql?

988

What is a temporal data type?

1052

What is pragma in pl sql?

1110

What is pls integer?

1045

What is rank () in sql?

941

How do you optimize a stored procedure in sql?

957

Why do we need cursors in pl sql?

1082

How do I find duplicates in two columns?

1169

What does the argument [or replace] do?

1082