row_number()
分配排名:select step, page,
row_number() over (partition by page, seqnum - seqnum_p order by step) as ranking
from (select t.*,
row_number() over (order by step) as seqnum,
row_number() over (partition by page order by step) as seqnum_p
from t
) t;