select column1, column 2, count('X') from Table

Q3. How will you fetch duplicate values from a DB2 table?

Question Posted / ganesh

Answer Posted / ganesh

select column1, column 2, count('X') from Table_name
group by column1, column 2
having integer(count('X')) > 1

Is This Answer Correct ?

16 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is syscat in db2?

1068

What is deadlock in db2?

1116

Explain package in db2 and its advantages?

1269

What is the connection string to connect to the DB2 Database ?

1171

What is the physical storage length of date data type?

1304

What are the benefits of using the db2 database?

1287

Is the primary key a clustered index?

1198

What is check constraint in db2?

1163

What do you mean by cursor?

1029

Which command is used to connect to a database in DB2 ? Give the Syntax.

1146

what is the sqlcode -501

13293

Differentiate between cs and rr isolation levels? Where do you specify them?

1115

What parameters are used to control the free space in DB2?

1094

What is rct?

1284

What is runstats db2?

1073