OVER함수1 [DB] OVER()함수 SELECT ROWNUM , COUNT (TEST_SEQ) OVER () TOTAL_CNT , COUNT ( TEST _SEQ) OVER () - ROWNUM + 1 display_no FROM TEST _STUDENT CS AND TOTAL_CNT + 1 - display_no > ( ('1' - 1)*'10' ) AND ( ('1' - 1)*'10' ) + '10' >= TOTAL_CNT + 1 - display_no AND TOTAL_CNT + 1 - display_no > 0 AND 0 + #{numPerPage} >= TOTAL_CNT + 1 - display_no AND TOTAL_CNT + 1 - display_no > ( (#{currentPage} - 1)*#{numPerPage} ) A.. 2024. 1. 18. 이전 1 다음