http://www.postgresqltutorial.com/postgresql-row_number/ ROW_NUMBER() OVER( [PARTITION BY column_1, column_2,…] [ORDER BY column_3,column_4,…] )
Read moreTag: number
[sql]이전 글, 제목, 다음 글, 제목
SELECT no,title from table WHERE no = (SELECT max(no) FROM table WHERE no < ‘${id}’) SELECT no,title from table WHERE[…]
Read more