LAST_VALUE()

Синтаксис

LAST_VALUE(column) OVER ([PARTITION BY column] ORDER BY column ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)

Примеры

SELECT user_id, amount,
  LAST_VALUE(amount) OVER (
    PARTITION BY user_id
    ORDER BY created_at
    ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
  ) AS last_order_amount
FROM orders;

Важно знать

• ⚠Без ROWS BETWEEN ... UNBOUNDED FOLLOWING вернёт значение текущей строки, не последнее.

Смотрите также