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 the difference between using bind () and rebind () methods of naming class?

1111

How to execute stored procedures?

879

Explain what are the various isolation levels possible?

840

what is the role of the cursor in db2?

840

What are the bind parameters ibm db2?

830

Is db2 a mainframe database?

765

Define check constraint.

861

What is the information associated with sysibm.syslinks table?

901

can we view the access paths created by dbrm ? how ? thx

6698

What r the comman abends in db2, jcl and cobol???????

2046

What types of tables are there in the db2 database?

824

What is the latest version of ibm db2?

996

If I have a view which is a join of two or more tables, can this view be updateable?

925

On which levels locks can be applied?

894

Mention the definition of cobol in varchar field.

924