sql board

페이징처리를 하는이유

1. 1-------
2. 2------
3. 3---
4. 4---
5. 5------

• 12345

최신글은 맨앞 1page

하나의 게시물을 페이지로 표시할때 boardVO로 표시 ROWS 인과 동시에 PAGES

ListVO도 표현해줘야한다.

SQL> col hits for 999;

SQL> col hits for 999

SQL> col content for 999

SQL> col content for 999;

COL TITLE FOR 20

SQL> CREate table book(

    book_no number primary key,

    title varchar2(100) not null,

    price number not null);

create sequence book_seq nocache;

insert into book(book_no, title, price) VALUS(book_seq.nextVal,'몽실언니,1200)
insert into book(book_no, title, price) VALUS(book_seq.nextVal,'몽실언니,1200)

SELECT BOOK_NO, TITLE, PRICE, ROWNUM, CEIL(ROWNUM/3) AS page FROM BOOK ORDER BY book_no DESC

select book_no, title, price from booㅏ

select book_no, title, price, ceil(rownum/3) page FROM(

SELECT book_no, title, price from book ORDER BY book_no DESC);

select book_no, title, price,page from

(SELECT book_no, title, price