select count(*),ss from dd group by ss having count(*)>1

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 / "d"

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

Answer Posted / "d"

select count(*),ss from dd group by
ss having count(*)>1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which is faster joins or subqueries?

991

What port does sql server use?

1063

What does the acronym acid stand for in database management?

1032

how many triggers are allowed in mysql table? : Sql dba

1071

Where is pl sql used?

954

what is a composite key ? : Sql dba

1062

Can we update views in sql?

940

Explian rowid, rownum?

1012

Which software is used for pl sql programming?

990

What is the purpose of using pl/sql?

1146

What are the different sql commands?

1073

What are inner outer left and right joins in sql?

1016

Can a composite key be null?

979

What are secondary keys?

971

What happens when a trigger is associated to a view?

915