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 |
Describe what a storage group(STOGROUP) is?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
How to fetch the uncommited data from table ?
What does db2 plan contain?
What is difference between isnull and coalesce?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
What is db2?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is buffer pool in the db2 database?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Give a brief description of db2 isolation levels?
what is the difference between join and union?