number

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

SELECT no,title from table WHERE no = (SELECT max(no) FROM table WHERE no < ‘${id}’) SELECT no,title from table WHERE