[postgresql]row_number

http://www.postgresqltutorial.com/postgresql-row_number/

ROW_NUMBER() OVER(
    [PARTITION BY column_1, column_2,…]
    [ORDER BY column_3,column_4,…]
)