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

Which component is responsible for db2 startup and shutdown?

813

Describe major components of db2?

860

What is precompiler in db2?

772

can all users have the privilage to use the sql statement select * (dml)?

858

What does sqlcabc has?

797

List out the data types available.

922

What is bufferpool in db2?

810

How does cobol compile db2 program?

816

What is the use of commit in db2?

823

What is the use of value function?

848

How to find schema of a table in db2?

759

What do you mean by cursor?

782

What is meant by dclgen?

858

What is universal database?

836

What is the latest version of ibm db2?

974