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 would you pass hints to the sql processor?

978

explain primary keys and auto increment fields in mysql : sql dba

969

how do you login to mysql using unix shell? : Sql dba

1075

What do you understand by pl/sql records?

1011

How to convert comma separated string to array in pl/sql?

1173

What is a natural join sql?

963

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

1243

What are the types of dbms?

968

Can variables be used in sql statements?

1028

How to write a query to show the details of a student from students table whose

992

How many types of sql are there?

984

What is sqlcommand?

1021

How do you determine the current isolation level? : Transact sql

1149

Can you join views in sql?

949

How many types of primary keys are there?

1028