雪花:窗口函数'range‘不支持，如何查询？

SELECT column1, column2, SUM(column3) OVER (ORDER BY column1 ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS running_total
FROM your_table;

SELECT t1.column1, t1.column2, SUM(t2.column3) AS running_total
FROM your_table t1
JOIN (
    SELECT column1, column3, ROW_NUMBER() OVER (ORDER BY column1) AS row_num
    FROM your_table
) t2 ON t1.column1 >= t2.column1 - 3 AND t1.column1 <= t2.column1
GROUP BY t1.column1, t1.column2;