jsp 게시판 페이징 구현

jsp 게시판 페이징 구현

 

-- 1page
select  X.*
from (
    select rownum as rnum, A.*
    from (
        select *
        from board
        order by num
        ) A
    where rownum <= 10) X
where X.rnum >= 1;

 

-- 2page
select  X.*
from (
    select rownum as rnum, A.*
    from (
        select *
        from board
        order by num
        ) A
    where rownum <= 20) X
where X.rnum >= 11;

 

 

 

 

webStudy11.zip