select * from education where rownum < ( select max(rownum) from educat

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

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

Answer Posted / harish

select * from education where rownum < ( select max(rownum)
from education group by <column_name> )

Is This Answer Correct ?

15 Yes

24 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why stored procedure is faster than query?

1068

Is natural join same as inner join?

948

what is bdb (berkeleydb)? : Sql dba

1038

What is lexical units in pl sql?

1153

Which nosql database is best?

987

Can sql developer connect to db2?

1057

Explain ttitle and btitle.

1124

what are the authentication modes in sql server? How can it be changed? : Sql dba

1441

Write a query to display the current date in sql?

1031

Why do we need sharding?

1001

Is the primary key an index?

1029

Define concurrency control. : Transact sql

1194

What is oracle sql developer?

1070

What is the best sql course?

989

What is pl sql variable?

998