Query block example: Average employee sales
This example of a query uses OLAP window aggregation functions.
In this example, Informix® Warehouse Accelerator processes
the join between the employee
and sales
tables,
and then returns the result set to the Informix® database server. The
Informix® database server then processes the OLAP functions, RANK and
AVG.
SELECT e.emp_name,
RANK() OVER (PARTITION BY region
ORDER BY total_sales desc),
AVG(sales) OVER (PARTITION BY region, year)
FROM employee e, sales s
WHERE e.emp_id = s.emp_id;