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

what are date and time data types in mysql? : Sql dba

953

What are the parameter modes supported by pl/sql?

1080

define sql update statement ? : Sql dba

1099

what are the types of join and explain each? : Sql dba

1022

Explain two easy sql optimizations.

994

Can we call dml statement in function?

1026

how to drop an existing view in mysql? : Sql dba

1041

What is sql*loader and what is it used for?

1119

How to change sql*plus system settings?

1041

What is column?

974

what are the differences between char and nchar? : Sql dba

1096

What are different types of sql commands?

1094

Is ms sql traffic encrypted?

909

what is data integrity? : Sql dba

1017

Where is all the data on the internet stored?

987