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

Which component is responsible for processing sql statements and selecting access paths?

647


How do I add a column to a table in db2?

611


What is the purpose of using commit?

608


What is ibm db2 database?

526


What is a db2 schema?

756






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?

7476


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

576


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

598


What does db2 plan contain?

567


Why db2 is called db2?

587


How does cobol compile db2 program?

599


What do you mean by cursor?

578


What is dbrm? What it contains? When it will be created?

589


Can there be more than one cursor open for any program?

652


What is null in db2?

567