mirror of
https://github.com/hanzo-ds/sqlparser.git
synced 2026-10-30 20:53:50 +00:00
16 lines
563 B
SQL
16 lines
563 B
SQL
-- Origin SQL:
|
|
CREATE OR REPLACE VIEW asdf AS
|
|
SELECT id,
|
|
price * 1.5 AS computed_value,
|
|
row_number() OVER (
|
|
PARTITION BY category
|
|
ORDER BY created_at
|
|
RANGE BETWEEN 3600 PRECEDING AND CURRENT ROW
|
|
) AS rn
|
|
FROM source_table
|
|
WHERE date >= '2023-01-01';
|
|
|
|
|
|
-- Format SQL:
|
|
CREATE OR REPLACE VIEW asdf AS SELECT id, price * 1.5 AS computed_value, row_number() OVER (PARTITION BY category ORDER BY created_at RANGE BETWEEN 3600 PRECEDING AND CURRENT ROW) AS rn FROM source_table WHERE date >= '2023-01-01';
|