Integrate Software AG Products Using Digital Event Services 10.4 | Integrate Software AG Products Using Digital Event Services | MashZone NextGen Help | Appendix | Legacy Presto components | MashZone NextGen 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-name between rows n preceding and n following )
To apply a window to each row within a partition, see Partitions and Windows
(partition column-name order 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 © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release