AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C)

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

Question Posted / harish

Answers were Sorted based on User's Feedback

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

Answer / guest

C) SUM, MAX, AVG , MIN &COUNT

Is This Answer Correct ?

59 Yes

5 No

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

Answer / ramakrishna nattam

Is This Answer Correct ?

10 Yes

1 No

More DB2 Interview Questions

What is dclgen in db2?

My SQL is not performing well. Describe how will you fine tune it?

What are the abend codes occour in ur latest PROJECT in DB2

What is an asychronous write?

What is copy pending status in db2?

What are the four lockable units for DB2?

How to resolve -818 sql code in DB2?

What is db2 optimizer?

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

Q4. How will you get the count of record without using COUNT verb in query?

What is drop table?

For more DB2 Interview Questions Click Here