In SQL, which keyword is used for aggregating data in a SELECT statement?
- AGGREGATE
- GROUP
- SUM
- TOTAL
In SQL, the keyword used for aggregating data in a SELECT statement is SUM. It is used to calculate the sum of values in a particular column, providing a way to aggregate data and obtain meaningful insights from the dataset.
Loading...
Related Quiz
- Scenario: A company wants to ensure that every order placed in their system has a corresponding customer. Which type of constraint would you apply to the order table to enforce this rule?
- What are some common challenges faced during collaborative data modeling projects?
- Scenario: A multinational corporation requires a database to manage its various departments, employees, and projects. How would you approach the conceptual schema design to accommodate diverse business needs and future scalability?
- Document-based databases are well-suited for scenarios where the data _______ over time.
- _______ is a technique used to improve query performance by limiting the partitions that need to be scanned.