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 constant in pl sql?

519

What is pl sql record in oracle?

567

What is the use of index in hive?

549

Why do we use procedures in sql?

552

Is sql considered coding?

571

Is sql better than access?

546

what are the properties and different types of sub-queries? : Sql dba

508

What are keys in sql?

551

Which is better varchar or nvarchar?

550

How to fix oracle error ora-00942: table or view does not exist

572

What is informix sql?

540

What is difference between stored procedures and application procedures?

573

What is the process of debugging?

556

What is record data type?

518

What does closing a cursor do?

768