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

4 Answers
9055 Views
I also Faced
E-Mail Answers

Answer Posted / chidambara subbu

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

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the meaning concurrency in the db2 database?

1108

How do I create a view in db2?

1015

What is cobol db2?

991

How do I import data from excel to db2?

1061

What is cursor in dbms?

1056

Explain the contents that are a part of dclgen.

1087

Explain correlated sub-queries.

1025

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1040

What is the latest version of ibm db2?

1263

How to check table size in db2 sap?

1029

How can record locking be achieved in those DB2 versions which do not support it?

1072

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1142

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9181

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3198

What is the difference between plan and package in db2?

1104