SELECT City FROM Customers Group by City HAVING COUNT(City)

Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?

Question Posted / chidambara subbu

Answer Posted / chidambara subbu

SELECT City FROM Customers
Group by City
HAVING COUNT(City) > 1

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is db2 restart?

2119

What is db2 plan table?

1015

What is phantom read in db2?

1103

How do you stop a db2 database in linux?

975

Which command is used to connect to a database in DB2 ? Give the Syntax.

1063

What are the various isolation levels possible?

1074

How to find the number of rows in a db2 table?

1092

When the like statement is used?

1179

What are the various data types available in db2?

1046

How do I add a column in db2?

1020

What are union and union all?

961

What is db2 purescale?

965

What is nvl in db2?

1068

what is the responsibility of the construction superintendent

2110

What is the difference between bind and rebind in db2?

1419