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 is a schema? How is it useful in sql servers?

1037

What are tuples in sql?

1056

how to get a list of indexes of an existing table? : Sql dba

913

Explain the uses of database trigger.

1052

What is replication id?

886

What is PL/SQL Records?

1111

What is java sql driver?

1035

Can two tables have same primary key?

915

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

966

What is sap sql?

923

Enlist the advantages of sql.

935

What is %s in sql?

970

What is equi join in sql?

1007

what happens if null values are involved in expressions? : Sql dba

998

What is posting?

984