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
Mention the location where the output received from explain statement is stored.
What is the difference between bind and rebind in db2?
What is commit in db2?
What is ibm db2 connect?
What are the benefits of using the db2 database?
can all users have the privilage to use the sql statement select * (dml)?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What language is db2 written in?
How do you eliminate duplicate values in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is meant by union and union all?
What is meant by explain?
what is a corelated subquerry?
What are foreign keys in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?