AGGREGATE function support by DB2.
A) SUM & AVG
B) SUM, MIN & AVG
C) SUM, MAX, AVG , MIN &COUNT
D) NONE
Answers were Sorted based on User's Feedback
List out the three types of page locks that can be held.
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
How to select the duplicate rows from a table?
Can any one tell me about Restart logic in DB2.
What is the syntax for seeing the columns and data types of a table in the db2 database?
Can I use LOCK TABLE on a view?
Where is the output of EXPLAIN stored?
max number of columns in a db2 table?
Why do we bind in db2?
Why do we use cursor?
Give the COBOL definition of a VARCHAR field.
What is deadlock in db2?