<select id="listPage" resultType="ReplyVO">
<![CDATA[
select
rno, bno, replytext, replyer, regdate, updatedate
from
(
select /*+INDEX_DESC(tbl_reply pk_reply))*/
rownum rn, rno, bno, replytext, replyer, regdate, updatedate
from tbl_reply
where bno = #{bno}
and rno > 0
and rownum <= #{cri.page} * #{cri.perPageNum}
)
where rn > ( #{cri.page} -1) * #{cri.perPageNum}
]]>
</select>
댓글 없음:
댓글 쓰기