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
14893 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

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1201

What does sqlcabc has?

1014

What is isolation level in db2?

962

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2042

What is consistency token in db2?

1100

What is universal database?

1042

What is lock escalation in db2?

987

How do I delete a column in db2?

1070

What is the role of union all and union

1094

How does coalesce work?

981

what is a corelated subquerry?

1084

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1075

What are types of indexes?

1019

What is a db2 cursor?

1024

Explain in detail about buffer manager and its functionalities?

1028