Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?
Answer Posted / sanj
say col1 is having duplicates in table tabA.Then,
select col1 from tabA
group by col1 having (count(col1) > 1)
Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is the usage of open cursor command?
What are the rules for db2 programming?
Mention the definition of cobol in varchar field.
Explain the benefits you can get from mainframe connect?
Explain about rct in db2?
Define db2 and its databases?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is deadlock in db2?
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.
How do I delete a table in db2?
Is it possible using max on a char column?
When the like statement is used?
What is the physical storage length of date data type?
Mention the downsides of page level lock.
What is bufferpool in db2?