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

Which is better join or subquery?

1120

Explain the uses of a database trigger?

1017

How to get each name only once from an employee table?

1097

explain mysql aggregate functions. : Sql dba

972

what is single byte over head in oracle..?

2389

What packages are available to pl/sql developers?

1031

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1043

Explain architecture of sql server notification services?

1039

What is data type in database?

975

How to use sql*plus built-in timers?

1171

Explain the update statement in sql

971

List the various privileges that a user can grant to another user?

1033

What is the size of partition table?

1030

What is sql query optimization?

1090

What is not null in sql?

1037