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 rank dense_rank and partition in sql?

1044

Does a user_objects view have an entry for a trigger?

1018

What are literals in sql server?

1178

Can we insert data in view?

970

Difference between truncate, delete and drop commands?

1087

What is varchar example?

1038

How do I view a view in sql?

956

explain the difference between bool, tinyint and bit. : Sql dba

1010

Is it possible to sort a column using a column alias?

1055

What is sql entity?

1108

Can we enter data in a table in design view?

971

What does count (*) mean?

936

Mention what is the use of function "module procedure" in pl/sql?

1050

What is cursor explain with example?

992

What is an exception in PL/SQL? What are the two types of exceptions?

1316