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

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

Question Posted / ganesh

2 Answers
14969 Views
RBS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the syntax for FETCH in DB2 ?

1196

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2173

Explain what are the various isolation levels possible?

1039

What is the physical storage length of date data type?

1244

Can we update view in db2?

990

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1095

What is a db2 collection?

1026

What is package in cobol db2?

1113

How to connect to db2 database from windows command line?

1047

Is db2 a programming language?

1037

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2060

What is the maximum length of sqlca?

1512

How to retrieve rows from a db2 table in embedded sql?

1377

How does cobol compile db2 program?

1038

What is the purpose of using commit?

1086