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

What is coalesce in db2?

682


What is the role of union all and union

650


What is difference between rollback and commit?

628


What does db2 plan contain?

573


What do you mean by storage group (stogroup)?

583






How do I delete a column in db2?

678


What is concurrency?

709


How can we read records for specific member in CL? AND rpg?

233


What is the difference between cursor stability and repeatable read isolation levels?

679


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

585


What is check constraint in db2?

606


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

648


What is cursor stability in db2?

811


What is difference between alias and synonym in db2?

643


What are the rules for db2 programming?

641