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

Where do you specify them?

1167

What is access path in db2?

926

What is isolation level in db2?

943

What is iseries database?

991

Can you tell me how can you find out the # of rows updated after an update statement?

1046

What is an instance in db2?

987

What are the benefits of using the db2 database?

1156

What is an instance database?

1007

What is the maximum No of rows per page?

1013

How to access db2 tables in mainframe?

992

What is db2 purescale?

945

What is null in db2?

950

define clustering index.

980

Which command is used to remove all rows from a table?

1040

How does db2 sample database connect?

975