GBase 8a OLAP Window Functions in Practice: Ranking, Running Totals, MoM, and Ratio Analysis

GBase 8a fully supports OLAP window functions, making it a powerful gbase database for analytical workloads. This guide uses real sales scenarios to demonstrate ROW_NUMBER/RANK, moving aggregates, LAG/LEAD for period‑over‑period comparisons, ROLLUP subtotals, and how these functions execute in an MPP environment.

Window Function Syntax

function_name() OVER (

[PARTITION BY column] -- window group

[ORDER BY column] -- ordering within window