Function Category: Window Functions

cume_dist() — PostgreSQL window window function

cume_dist(): fractional row number within partition. PostgreSQL window functions — signature, volatility, version applicability and an illustrative example.

dense_rank() — PostgreSQL window window function

dense_rank(): integer rank without gaps. PostgreSQL window functions — signature, volatility, version applicability and an illustrative example.

first_value() — PostgreSQL window window function

first_value(): fetch the first row value. PostgreSQL window functions — signature, volatility, version applicability and an illustrative example.

lag() — PostgreSQL window window function

lag(): fetch the preceding row value. PostgreSQL window functions — signature, volatility, version applicability and an illustrative example.

last_value() — PostgreSQL window window function

last_value(): fetch the last row value. PostgreSQL window functions — signature, volatility, version applicability and an illustrative example.

lead() — PostgreSQL window window function

lead(): fetch the following row value. PostgreSQL window functions — signature, volatility, version applicability and an illustrative example.

nth_value() — PostgreSQL window window function

nth_value(): fetch the Nth row value. PostgreSQL window functions — signature, volatility, version applicability and an illustrative example.

ntile() — PostgreSQL window window function

ntile(): split rows into N groups. PostgreSQL window functions — signature, volatility, version applicability and an illustrative example.

percent_rank() — PostgreSQL window window function

percent_rank(): fractional rank within partition. PostgreSQL window functions — signature, volatility, version applicability and an illustrative example.

rank() — PostgreSQL window window function

rank(): integer rank with gaps. PostgreSQL window functions — signature, volatility, version applicability and an illustrative example.