DB2 can implement a join in three ways using a merge join,
a nested join or a hybrid join. Explain the differences?
No Answer is Posted For this Question
Be the First to Post Answer
What is isolation level in db2?
wht are the restrictions for union ?
difference between group clause and order clause
What is a buffer pool?
Is db2 a database?
Explain dclgen.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What is dynamic SQL?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
Can we update view in db2?
Q4. How will you get the count of record without using COUNT verb in query?