Aggregation

SELECT Sum(price)

FROM Product

WHERE manufacturer=‘Toyota’

SQL supports several aggregation operations:

SUM, MIN, MAX, AVG, COUNT

Except COUNT, all aggregations apply to a single attribute

SELECT Count(*)

FROM Purchase

Previous slide

Next slide

Back to first slide

View graphic version