Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?
- 4 Answers
- 9103 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
How is the value function used?
What does db2 blu stand for?
How to run db2 command in windows?
What is a storage group (stogroup)?
What is the role of schema in the db2 database?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What does reorg do in db2?
What is deadlock in db2?
What is db2 and what is the use of db2 optimizer?
What is netezza database?
What is explain plan in db2?
What is release/acquire in bind?
How can deadlocks be resolved?
Explain correlated sub-queries.
How to execute stored procedures?
