Which aggregation function in DB2 is used to calculate the average value of a numeric column?
- AVG()
- COUNT()
- MIN()
- SUM()
The AVG() function in DB2 is specifically designed to calculate the average value of a numeric column. It adds up all the values in the column and divides them by the total number of rows.
Loading...
Related Quiz
- What factors should be considered when determining the columns to include in an index?
- What does the version number of DB2 signify?
- What considerations should be made when using views in a distributed DB2 environment?
- Scenario: A DB2 developer needs to extract specific information from an XML document stored in the database. Which feature of DB2 can they use for this purpose?
- In what scenarios would denormalization be recommended in a database design?