select City, Country, count('X') from Customers group by City, C

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

Question Posted / ramana99

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

Answer Posted / ramana99

select City, Country, count('X') from Customers
group by City, Country
HAVING count('X') > 1
;

Is This Answer Correct ?

8 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does a deadlock mean in DB2?

1169

Why do we need reorg in db2?

990

What is consistency token in db2?

1145

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9216

Is db2 relational database?

981

what is db2 restart?

2162

What are the bind parameters ibm db2?

1054

What is clone table?

1047

B37 abend during spufi?

1456

Is db2 a database?

979

What is a dbrm in db2?

1025

Is ibm db2 free?

1014

What is the maximum length of sqlca?

1530

Define db2 and its databases?

1058