blob: 6f70690057f239fa00edea5a7968a673cb46250e [file] [log] [blame]
SELECT
dt,
dt2,
row_number() over(partition by round(dt),dt2 order by ceil(dt) asc null last ROWS BETWEEN 1 PRECEDING AND CURRENT ROW)
FROM
sum_example;