Logo
  • Submit a request
  • Sign in
  • Home
  • What's New

Window Functions

Window Functions are special functions where the result is dependent on the order and grouping of rows.

ArrayAgg

CumeDist

CumulativeAvg

CumulativeCorr

CumulativeCount

CumulativeMax

CumulativeMin

CumulativeStdDev

CumulativeSum

CumulativeVariance

FillDown

First

FirstNonNull

Lag

Last

LastNonNull

Lead

ListAgg

ListAggDistinct

MovingAvg

MovingCorr

MovingCount

MovingMax

MovingMin

MovingStdDev

MovingSum

MovingVariance

Nth

Ntile

Rank

  • 1
  • 2
  • ›
  • »

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.

© Sigma Computing
Links
  • Sigma Home
  • About Us
  • Start Your Free Trial
  • Contact Us
Support
  • Documentation
  • Function Index
Contacts
  • support@sigmacomputing.com