five minutes of funk, ljk.kr: 오라클-Rownum을-이용한-페이징쿼리에 달린 최근 댓글/트랙백 목록http://web20korea.com/web20korea's2008-12-30T08:15:10+09:00Textcube 1.7.1 : Risolutodd님의 댓글(dd)http://web20korea.com/29#comment232007-11-16T13:43:01+09:00select * from (
select rownum as rnum, IDX, TITLE, REGDATE, HITS, CATEGORY, VIEWTF, USER_IDX, USERNAME
from SAA_BOARD
where FLAG = '2'
) where rnum between 0 and 10
order by IDX desc;