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

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

Please Help Members By Posting Answers For Below Questions

What is copy pending and check pending in db2?

954

What do you mean by storage group (stogroup)?

984

Comment whether the cursor is closed during commit or not.

1042

Define buffer pool.

999

What os does db2 run on?

929

Define db2.

1067

what is the role of the cursor in db2?

1002

What is cobol db2?

935

What is a dbrm in db2?

971

Is db2 free?

1038

What is the use of predicate?

985

What is db2?

1126

What is buffer pool and list some of them?

984

What is the difference between oracle and db2?

1033

Mention the various locks that are available in db2.

976