select * from emp a , (select empno,count(*) from emp group by empno havi

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 / lakshmi narayana

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

Answer Posted / lakshmi narayana

select * from emp a ,
(select empno,count(*) from emp group by empno having count
(*) > 1) b
where a.empno = b.empno

Is This Answer Correct ?

27 Yes

10 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do rank () and dense_rank () differ?

1052

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1174

Is sql a programming?

982

Are subqueries better than joins?

981

What is sap sql?

989

How do I get sql certification?

979

what is the difference between clustered and non clustered index in sql? : Sql dba

1134

How do you modify a table in sql?

1132

How does an execution block start and end in pl sql?

957

What is sqlexception in java?

1001

What is sql profiling in oracle?

1071

What is nosql db?

975

What is multiple partition?

973

How do I sort a table in sql?

1053

List different type of expressions with the example.

938