Multiple choice technology databases

Anytime you mix aggregates with non-aggregates you must use the group by statement

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

While GROUP BY is commonly used with aggregates and non-aggregates, it's not the only approach. Window functions can combine aggregates with non-aggregated data without GROUP BY. Additionally, some databases allow mixing aggregates and non-aggregates when non-aggregates are functionally dependent on GROUP BY columns.

Keep practicing — related questions