AGGREGATE function support by DB2.
A) SUM & AVG
B) SUM, MIN & AVG
C) SUM, MAX, AVG , MIN &COUNT
D) NONE
Answer Posted / ramakrishna nattam
c
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Is ibm db2 free?
What is difference between alias and synonym in db2?
What is the physical storage length of the data types date, time, and timestamp?
What is db2 command?
How do I delete a column in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How do you stop a db2 database in linux?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is schema in db2?
Explain about rct in db2?
How do you pull up a query which was previously saved in qmf?
Is db2 a programming language?
How is a typical db2 batch pgm executed?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Can you tell me how can you find out the # of rows updated after an update statement?