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

Describe types of sql statements?

989

Can a composite key be null?

909

How to select unique records from a table?

998

what are the 'mysql' command line arguments? : Sql dba

1087

What are sql functions? Describe the different types of sql functions?

1056

Is keyword pl sql?

930

What does partition by mean in sql?

907

Inline the values in PL/SQL, what does it mean.?

1156

what is cursor. write example of it. What are the attributes of cursor.

1308

What are different types of keys?

1014

Is sql developer case sensitive?

943

what is oltp (online transaction processing)? : Sql dba

1012

How delete all records from table in sql?

927

How to place comments in pl/sql?

1095

Is id a reserved word in sql?

1090