Paging 쿼리(Query) 작성하기 with Oracle, MySQL by 신기용 about MySQL,Oracle,SQL
- * FROM ( SELECT PG1
- ROWNUM R_NUM FROM ( select m
- name like '%name%' ) PG1 WHERE ROWNUM <= /*count*/ 20 * /*startNum*/ 3 ) PG2 WHERE R_NUM > /*count*/ 20 * ( /*startNum*/ 3 - 1 ) AND ROWNUM <= /*count*/ 20 ;