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

Why is stored procedure faster than query?

950

How to get unique records from a table?

956

What is error ora-01000: maximum open cursors exceeded

1134

What is composite primary key in sql?

992

what are local and global variables and their differences? : Sql dba

1066

Can variables be used in sql statements?

1028

What is record type in pl sql?

982

How many joins can you have in sql?

930

how do you tune the slow running queries in oracle db , explain the methodology

2678

how to delete an existing column in a table? : Sql dba

1003

Should I use mbr or gpt?

1023

Is join same as left join?

1029

How do I view tables in mysql?

976

What are packages in pl sql and also explain its advantages?

1027

Can we insert delete data in view?

944