select * from education where rowid in (select min(rowid) from ex group b

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 / a.balakrishna

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

Answer Posted / a.balakrishna

select * from education where rowid in (select min(rowid)
from ex group by sno having count(*)>1);

100% it is true

Best of luck

9177509010

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does oracle roll back the transaction on an error?

979

What are the most important ddl statements in sql?

1056

Why do we need a foreign key?

1043

Define a temp table?

987

What does count (*) do in sql?

969

What are the different types of tables in sql?

951

What is a nested table in word?

934

What is clustered index sql?

957

What is scope and visibility in PL/SQL?

1150

How to add new employee details in an employee_details table with the following details

1058

what are the advantages of using stored procedures? : Sql dba

1079

Can we connect to postgresql using sql developer?

962

What is procedure in pl sql?

995

Can I learn sql in a week?

1031

What are the advantages of normalization?

1052