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 the difference between using bind () and rebind () methods of naming class?

1332

define clustering index.

980

What is iseries database?

995

What is the use of value function?

1076

Which command is used to remove all rows from a table?

1042

What are the full forms of spufi and dclgen and why are they used?

1027

How many databases can be created inside an instance in db2 ?

982

How do I start db2 in windows?

1029

What is netezza database?

961

What are foreign keys in db2?

1038

Explain about open switch business continuity software?

1074

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1046

What is difference between isnull and coalesce?

1012

What is a db2 schema?

1179

Define declaration generator (dclgen).

1068