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
How to rename a table in DB2 ?
How to execute stored procedures?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is consistency token in db2?
On which levels locks can be applied?
What is a collection in db2?
What is dclgen in db2?
What is the reason behind not using select * in embedded sql programs?
What is difference between isnull and coalesce?
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 iseries database?
Mention the various locks that are available in db2.
How do you simulate the explain of an embedded sql statement in spufi/qmf?
what is a corelated subquerry?
What are the uses of db2 optimizer?