Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?
- 4 Answers
- 8087 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
Where can you declare a cursor in a cobol-db2 program?
What is runstats and reorg in db2?
Where do you specify them?
How to find the maximum value in a column in the db2 database?
What is nvl in db2?
Mention the location where the output received from explain statement is stored.
What is the use of reorg in db2?
What is the purpose of rollback and commit?
How do I import data from excel to db2?
What does db2 stand for?
What is role in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What db2 400?
What do you mean by rollback?
What is the role of schema in the db2 database?
