select count(<Duplicate_FieldName>),fees from Table Name group by &

how to retrieve only duplicate values in a table

Question Posted / p.rajasekar

Answer Posted / p.rajasekar

select count(<Duplicate_FieldName>),fees
from Table Name
group by <Duplcate_FieldName>
having count(<Duplicate_FieldName>)>1

Regards
P.Rajasekar

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we update views in sql?

985

Can a view be mutating? If yes, then how?

1087

How to use sql*plus built-in timers?

1260

how can we find the number of rows in a table using mysql? : Sql dba

1123

What is pivot table in sql?

1171

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1092

how to convert dates to character strings? : Sql dba

1250

Explian rowid, rownum? What are the psoducolumns we have?

1045

How does sql developer connect to oracle database?

1051

Is sql dba a good career? : SQL DBA

1047

What is offset and limit in sql?

1103

What is the purpose of the partition table?

1089

What are the different tcl commands in sql?

1228

What is nested table in pl sql?

1121

is it possible to pass an object or table to a procedure as an argument?

1176