say col1 is having duplicates in table tabA.Then, select col1 from tabA

Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?

Question Posted / sanj

Answer Posted / sanj

say col1 is having duplicates in table tabA.Then,

select col1 from tabA
group by col1 having (count(col1) > 1)

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How is deadlock resolved?

1144

Can we delete records from view?

962

How to create backup table in db2?

1086

How do I delete a table in db2?

1061

what is a corelated subquerry?

1120

Explain dclgen.

1192

Explain about dbrm.

1037

What are the uses of db2 optimizer?

1290

B37 abend during spufi?

1452

what is diffrence b/w file-aid tool and file-aid utility???

4887

What is the role of the data page in the db2 database?

1020

What is the difference between cursor and select statement?

1094

Can you use max on a char column?

1091

What are the contents of a dclmgen?

1120

What is nvl in db2?

1087