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

How can we solve sql error: ora-00904: invalid identifier?

1258

How are sql commands classified?

1095

What are the sql aggregate functions?

1140

What is a constraint?

1029

What is faster join or subquery?

1018

What is trigger in sql? Explain

1000

What is a primary key called that is made up of more than one field?

1356

What is sql profiler in oracle?

1101

What is rtm stands for?

1111

Can we have two clustered index on a table?

1028

How do you remove duplicate records from a table?

946

What does joining a thread mean?

1024

What is the benefit of foreign key?

1024

Can procedure in package be overloaded?

1093

How do you go back in sql?

994