Advertisement

Window Functions

  • Clare Churcher
Chapter

Abstract

Window functions were added to standard SQL in 2003 and provide considerable extra capability for dealing with aggregation. Window functions allow us to perform aggregates on a “window” of data based upon the current row. This provides an elegant way to specify queries to perform actions such as ranking, running totals, and rolling averages. Window functions also provide considerable flexibility when it comes to grouping data for aggregation as they allow a single query to have several different groups or partitions. It is also possible to reference the data contributing to the aggregate from within the query. This allows the underlying data to be compared to the aggregate.

Keywords

Window Function Entry Table Rolling Average Single Query Considerable Flexibility 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Clare Churcher 2016

Authors and Affiliations

  • Clare Churcher
    • 1
  1. 1.Studio B ProductionsGreat NeckUSA

Personalised recommendations