select * from education a where rownum>(select max(rownum) 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 / kumargvk

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

Answer Posted / kumargvk

select * from education a where rownum>(select max(rownum)
from education b where b.rno=b.rno)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does pl/sql support create command?

1168

What is a temporal table?

980

How to call a javascript function from pl sql?

1187

How many disk partitions should I have?

1040

What is raw datatype in sql?

1106

What is %type in sql?

1020

What is a rank in sql?

1007

what is bdb (berkeleydb)? : Sql dba

1093

What is a constraint? Tell me about its various levels.

1247

Does google use sql?

1007

What is the use of triggers?

1083

what are the different type of normalization? : Sql dba

1070

Explain the difference between sql and mysql.

1113

what are the types of subquery? : Sql dba

1160

What is primary and foreign key?

1123