What is the purpose of aggregation functions in DB2?
- To manipulate data types
- To modify table structures
- To perform calculations on sets of rows
- To perform sorting operations on columns
Aggregation functions in DB2 are used to perform calculations on sets of rows, such as computing sums, averages, counts, minimum, and maximum values. These functions help in deriving meaningful insights from data.
Loading...
Related Quiz
- Which DB2 command is used to restore a database from a backup?
- Explain the concept of functional dependencies and their role in normalization.
- The DELETE statement in SQL is used to remove ________ from a database table.
- Indexes with INCLUDE columns in DB2 can optimize ________.
- Stored procedures in DB2 can be invoked from ________.