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 db journal file?

508

What will you get by the cursor attribute sql%notfound?

582

What is procedure explain with example?

519

What is the difference between database trigger and stored procedure?

538

Can a commit statement be executed as part of a trigger?

592

Is natural join and inner join same?

479

Why does sql need a server?

551

What is the difference between sql and isql*plus?

503

What is the difference between a database and a relational database?

546

Is pl sql useful?

529

What is a field in a database?

553

How to take user input in pl sql?

688

What is pl sql collection?

514

Can we insert data into materialized view?

492

what is the difference between delete and truncate statement in sql? : Sql dba

533