5 SQL window-function traps that show up in data engineering interviews (with runnable DuckDB examples)
Default frames, ties, LAST_VALUE, filters before windows and sparse moving averages. Five small traps that separate knows SQL from writes correct pipelines.
Oct 12, 20265 min read10