상황
SELECT *
FROM(
SELECT *
FROM board
CONNECT BY PRIOR post_num = parent_num
START WITH parent_num IS NULL
ORDER SIBLINGS BY create_dt DESC -- 부모 글은 최신순, 답글은 오래된 순
)
OFFSET 0 ROWS FETCH NEXT 5 ROWS ONLY; -- 처음 데이터(0)부터 5개만 반환
댓글