unused_columns_window.sql 145 B

123456789
  1. USE plato;
  2. SELECT
  3. a,
  4. lag(a) over w as prev_a,
  5. min(a) over w as min_a
  6. FROM Input
  7. WINDOW w AS (PARTITION BY b ORDER by c)
  8. ORDER BY a;