Examples

The examples in this section describe how to use analytic functions.

  • Window aggregation on a grouping select
    • Selecting the top n within each partition
  • Inverse distribution functions
    • Median calculation
  • Ranking function examples
  • Hypothetical set function
  • Ntile function
  • Width_bucket function