row_number presto

row_number

なるほどわからん

Returns a unique, sequential number for each row, starting with one, according to the ordering of rows within the window partition.

https://prestodb.io/docs/current/functions/window.html