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


Please Help Members By Posting Answers For Below Questions

Mention the location where the output received from explain statement is stored.

854


What is the difference between bind and rebind in db2?

1184


What is commit in db2?

808


What is ibm db2 connect?

747


What are the benefits of using the db2 database?

886


can all users have the privilage to use the sql statement select * (dml)?

853


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2664


What language is db2 written in?

787


How do you eliminate duplicate values in db2?

897


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

1828


What is meant by union and union all?

783


What is meant by explain?

853


what is a corelated subquerry?

834


What are foreign keys in db2?

820


Is it possible to create an Instance in DB2 using DB2 Control Center ?

844