Presto Analytics : RAQL Queries : Over Techniques
Over Techniques
Column Expression
Example
over
()
To use the entire dataset as one partition, see the middle subquery in From Subqueries.
(partition column-name)
To group with a simple partition, see Group and Analyze Rows with Row Detail
(partition column-namebetween rows npreceding and nfollowing )
To apply a window to each row within a partition, see Partitions and Windows
(partition column-nameorder by column-name)
To obtain running calculations in partitions, see Running Aggregates.
To provide an index of each row or ranking within each partition, see Number or Rank Rows.
any-partition-expression
For examples of statistical analysis, see Analytic Functions for Partitions and Windows.
Copyright © 2013-2015 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback