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 maximum length of sqlca?

863

What is a db2 cursor?

618

Define data page.

626

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

643

What are the prerogatives?

612

What is the result of open cursor statement?

634

How do I import data from excel to db2?

607

What are iseries servers?

562

Can we insert update delete in view?

571

What is the role of schema in the db2 database?

649

What is db2 and what is the use of db2 optimizer?

648

What is difference between rollback and commit?

616

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

636

How does db2 sample database connect?

566

What is the use of commit in db2?

628