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
What is declare cursor?
Before you give the explain statement, what are the prerogatives?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What does reorg do in db2?
How can deadlocks be resolved?
What is the meaning concurrency in the db2 database?
What is bind in db2?
Mention the different locking levels that are available in db2.
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 the maximum size of varchar data type in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Explain the benefits you can get from mainframe connect?
How is a typical db2 batch pgm executed?
What is the difference between oracle and db2?
Can you use max on a char column?