Which of the following can produce scalar and vector aggregates?
A) Order By
B) Group By
C) Having
D) Sort

Name: Which of the following can produce scalar and vector aggregates? A) Order By B) Group By C) Having D) Sort
Brand: Quizplus
Rating: 4.8 (43 reviews)

Question

Quizplus · Accepted Answer

The "Group By" clause is used in SQL to arrange identical data into groups, which can then be used to produce scalar aggregates (like SUM, AVG) and vector aggregates (like COUNT, MAX, MIN).

Which of the Following Can Produce Scalar and Vector Aggregates