For the MAX window function that computes a group, cumulative, or moving maximum value, see Window Aggregate Functions.