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
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is a collection?
What is db2 bind process?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What techniques will be used to avoid deadlock??
What is clone table?
How do I delete a table in db2?
How to design maps
What r the comman abends in db2, jcl and cobol???????
What are foreign keys?
How to compare data between two tables in db2?
Name the lockable units in DB2?