[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,…\]
)

Written by@MuseKim
Muse Kim