Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Function_name is one of the following:

  • Running aggregate Window function: row-numbercume_dist(), dense_rank(), dense_rankfirst_value(), lag(), last_value(), lead(), nth_value(), ntile(), rank(), ratio_to_report(), percentrow_ranknumber(), ntilepercent_rank()
  • SQL aggregate function: count(), sum(), avg(), min(), max(), etc
  • SQL++ aggregate function: array_count(), array_sum(), strict_count(), strict_sum(), etc

...