mirror of
https://github.com/hanzo-ds/sqlparser.git
synced 2026-10-30 20:53:50 +00:00
18 lines
1015 B
SQL
18 lines
1015 B
SQL
-- Origin SQL:
|
|
SELECT aggregation_target AS aggregation_target,
|
|
timestamp AS timestamp,
|
|
step_0 AS step_0,
|
|
latest_0 AS latest_0,
|
|
step_1 AS step_1,
|
|
latest_1 AS latest_1,
|
|
step_2 AS step_2,
|
|
min(latest_2) OVER (PARTITION BY aggregation_target
|
|
ORDER BY timestamp DESC ROWS BETWEEN UNBOUNDED PRECEDING AND 0 PRECEDING) AS latest_2,
|
|
min(latest_1) OVER w AS latest_1
|
|
FROM t0
|
|
WINDOW w AS (PARTITION BY aggregation_target
|
|
ORDER BY timestamp DESC ROWS BETWEEN UNBOUNDED PRECEDING AND 0 PRECEDING);
|
|
|
|
-- Format SQL:
|
|
SELECT aggregation_target AS aggregation_target, timestamp AS timestamp, step_0 AS step_0, latest_0 AS latest_0, step_1 AS step_1, latest_1 AS latest_1, step_2 AS step_2, min(latest_2) OVER (PARTITION BY aggregation_target ORDER BY timestamp DESC ROWS BETWEEN UNBOUNDED PRECEDING AND 0 PRECEDING) AS latest_2, min(latest_1) OVER w AS latest_1 FROM t0 WINDOW w AS (PARTITION BY aggregation_target ORDER BY timestamp DESC ROWS BETWEEN UNBOUNDED PRECEDING AND 0 PRECEDING);
|