LAST_VALUE

1
SELECT 
2
  date,
3
  stock_symbol,
4
  price,
5
  LAST_VALUE(price) OVER (
6
    PARTITION BY stock_symbol 
7
    ORDER BY date
8
    ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
9
  ) AS closing_price
10
FROM stock_prices;

1
SELECT 
2
  month,
3
  actual_sales,
4
  LAST_VALUE(actual_sales) OVER (
5
    ORDER BY month
6
    ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
7
  ) AS final_sales,
8
  LAST_VALUE(actual_sales) OVER (...) - actual_sales AS gap_to_final
9
FROM monthly_performance;

1
-- SALAH: Akan menghasilkan nilai row saat ini
2
SELECT LAST_VALUE(price) OVER (ORDER BY date) AS wrong;
3
 
4
-- BENAR: Gunakan frame clause
5
SELECT LAST_VALUE(price) OVER (
6
  ORDER BY date 
7
  ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
8
) AS correct;