개발/DB(Oracle, MySQL)
row_num과 페이징
쵸코푸들이장군
2018. 2. 11. 09:22
select * from(
SELECT *, ROW_NUMBER() OVER (ORDER BY chart_seq DESC) as rnum
FROM t_chart
) aa
WHERE aa.rnum BETWEEN 11 AND 20