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 table space in db2?

1030

Explain about mirror activator disk mirroring?

1018

What is node in db2?

1051

What is a db2 schema?

1242

What is a db2 package?

1072

What is bufferpool in db2?

1059

What is database manager in db2?

1031

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1191

What is the syntax for FETCH in DB2 ?

1231

Is db2 a mainframe?

1053

What is the physical storage length of time data type?

1140

What is ibm db2 client?

948

What is host variable?

1065

What is db2 bind?

1090

How many databases are there?

1064