select id, name from (select id,

how to retrieve only duplicate values in a table

Question Posted / suresh babu

Answer Posted / suresh babu

select
id,
name
from
(select
id,
name
from
find_dup
group by
id,
name
having
count(*) > 1);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is rowid in sql?

508

What packages are available to pl/sql developers?

597

Explain normalization and what are the advantages of it?

516

Can we use join in subquery?

565

What is query execution plan in sql?

563

what is the stuff function and how does it differ from the replace function? : Sql dba

618

What is partition by in sql?

569

How to take user input in pl sql?

699

How subquery works in sql?

539

Why indexing is needed?

516

Can 2 queries be executed simultaneously in a distributed database system?

640

What is scalar function in sql?

527

What are the two types of periodical indexes?

503

What does (*) mean in sql?

527

What is db journal file?

516