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
50718 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 scalar data type in pl sql?

1020

What is the difference between delete and truncate commands?

978

What are the different operators available in sql?

963

how can you create an empty table from an existing table? : Sql dba

1080

What is pl sql block in dbms?

952

What is the usage of nvl function?

984

Why functions are used in sql?

931

Define join and name different types of joins?

960

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

970

Can variables be used in sql statements?

982

Why use truncate instead of delete?

962

How bulk collect improves performance?

948

What is cross join sql?

868

What is the difference between a subquery and a join?

1013

How does pl sql work?

915