Aggregation

Example



select *

from Employees as e
group by e.department as departments
order by avg(select e.salary from partition)

The type of the result is:

List<struct(department: integer,

partition: Bag<struct(e:Employee)> >

Previous slide

Next slide

Back to first slide

View graphic version