SELECT <COLUMN_1> FROM TABLENAME GROUP BY COLUMN

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

Question Posted / azharuddinsyed

4 Answers
9242 Views
I also Faced
E-Mail Answers

SELECT <COLUMN_1> FROM TABLENAME
GROUP BY COLUMN_1
HAVING COUNT(COLUMN_1) > 1

OR

SELECT <COLUMN_1> FROM TABLENAME
GROUP BY COLUMN_1
HAVING COUNT(*) > 1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Mention the various locks that are available in db2.

1085

What is the latest version of ibm db2?

1335

What is ibm db2 connect?

1054

What is db2 bind process?

1290

What is db2 optimizer?

1309

What is an instance database?

1096

Which isolation level provides maximum concurrency?

1203

How do I connect my db2 database to ibm?

1085

What is the maximum size of varchar data type in db2?

1177

What is load utility in db2?

1229

What is temporal table in db2?

1101

Where do you specify them?

1370

What is role in db2?

1160

How to resolve deadlock issue

20318

Which component is responsible for db2 startup and shutdown?

1084