Q3. How will you fetch duplicate values from a DB2 table?
Answers were Sorted based on User's Feedback
Answer / ganesh
select column1, column 2, count('X') from Table_name
group by column1, column 2
having integer(count('X')) > 1
| Is This Answer Correct ? | 16 Yes | 4 No |
What is filter factor?
What is the database descriptor?
What is meant by AUTO COMMIT?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
What is Skeleton cursor table (SKCT)?
What is a trigger in the db2 database?
how to fetch first 100 rows in db2
What is Call attach facility? How does it work?
Are views updateable?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
Is db2 a database?
What is dpf in db2?