AGGREGATE function support by DB2.
A) SUM & AVG
B) SUM, MIN & AVG
C) SUM, MAX, AVG , MIN &COUNT
D) NONE
Answers were Sorted based on User's Feedback
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
How do I create a view in db2?
What is dclgen in db2?
What is the difference between cursor and select statement?
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 an instance database?
What is copy pending and check pending in db2?
how will you retrieve first record in table
List down the data types in the db2 database.
How many databases are there?
What is tablespace?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?