Ranking and Windowing Analytic Functions

Analytic Functions are designed to address such problems as “Calculate a running total”, “Find percentages within a group”, “Top-N queries”, “Compute a moving average” and many more. Analytic Functions add extensions to the SQL language that make these operations easier to code.

Kognitio supports many of the ANSI SQL:1999 standard analytic functions and some extensions.