For Sample: ---------- select count(pmid) as Occurances,pmid from table

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

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

Answer Posted / balaji

For Sample:
----------

select count(pmid) as Occurances,pmid from tablename group
by pmid having count(pmid)>1

Is This Answer Correct ?

7 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we perform dml in function?

1132

How to order siblings in oracle hierarchy queries?

1111

What are the three pl sql block types?

1049

How does left join work in sql?

1040

What is the location of pre_defined_functions.

1208

What is sequence in sql?

1076

What is meant by cursor in sql?

1061

What is a function in oracle pl sql?

1098

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1224

what are aggregate and scalar functions? : Sql dba

1107

What are character functions?

1141

What is difference between sql and excel?

1179

Can we use commit inside a trigger?

1147

What is nvarchar max in sql?

1073

what is offset-fetch filter in tsql? : Transact sql

998