C) SUM, MAX, AVG , MIN &COUNT

AGGREGATE function support by DB2.
A) SUM & AVG
B) SUM, MIN & AVG
C) SUM, MAX, AVG , MIN &COUNT
D) NONE

Question Posted / guest

Answer Posted / guest

Is This Answer Correct ?

59 Yes

5 No

Please Help Members By Posting Answers For Below Questions

List out the buffer pools in db2

1066

How to restart a DB2 program?

1883

Is ibm db2 free?

998

How to create backup table in db2?

1079

What are db2 objects?

1037

How do you concatenate the firstname and lastname from emp table to give a complete name?

1069

What do you mean by between and in? Is between inclusive of specified range values?

1084

What do you mean by cursor?

988

How to run db2 command in windows?

1181

What action db2 takes when a program aborts in the middle of a transaction?

1142

List down the data types in the db2 database.

1107

How will you return the number of records in table?

922

Outputs of explain are with matchcols = 0. What does this signify?

1048

What is cobol db2?

986

is it compulsory commitment control in journal?

2470