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