select * from emp where sal in(select sal from emp group by sal having cou

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

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

Answer Posted / naresh

select * from emp where sal in(select sal from emp group by
sal having count(sal)>1);

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are analytic functions in sql?

1034

What is the use of sqldataadapter?

979

What is pl sql collection?

978

what is the difference between truncate and drop statements? : Sql dba

1134

What does 0 mean in sql?

969

What is lookup table in sql?

1054

Can we use view in stored procedure?

905

what is denormalization. : Sql dba

1120

Explain unique key in sql.

1018

What are crud methods?

1041

What is anonymous block in sql?

1126

what is a table in a database ? : Sql dba

1048

Can you have more than one trigger on a table?

1005

What is cursor status?

1193

What is substitution variable in pl sql?

1051