AGGREGATE function support by DB2.
A) SUM & AVG
B) SUM, MIN & AVG
C) SUM, MAX, AVG , MIN &COUNT
D) NONE
Answer Posted / guest
C) SUM, MAX, AVG , MIN &COUNT
Is This Answer Correct ? | 59 Yes | 5 No |
Post New Answer View All Answers
Which component is responsible for processing sql statements and selecting access paths?
How do I add a column to a table in db2?
What is the purpose of using commit?
What is ibm db2 database?
What is a db2 schema?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What does db2 plan contain?
Why db2 is called db2?
How does cobol compile db2 program?
What do you mean by cursor?
What is dbrm? What it contains? When it will be created?
Can there be more than one cursor open for any program?
What is null in db2?