Aggregation functions like SUM, AVG, MIN, and MAX operate on a set of _______.
- Columns
- Rows
- Tables
- Values
Aggregation functions like SUM, AVG, MIN, and MAX operate on a set of values. These functions perform calculations on a column of data to produce a single result, such as the sum or average of the values in that column. Understanding how to use aggregation functions is crucial for data analysis and reporting.
Loading...
Related Quiz
- Scenario: You are designing a social networking platform where users can follow other users and share posts. Which NoSQL database type would you choose and why?
- What is a superclass in the context of database modeling?
- What is the primary characteristic of a Star Schema?
- In a one-to-many relationship, which entity holds the foreign key?
- In document-based modeling, how are relationships between documents typically represented?