![[SQL] 계층형 쿼리(댓글) START WITH / CONNECT BY PRIOR 포스팅 썸네일 이미지](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FsZB9L%2FbtqVRwjmYIJ%2FyNiSYTtHXZVubWRSi9ebX1%2Fimg.png)
SQL/Oracle
[SQL] 계층형 쿼리(댓글) START WITH / CONNECT BY PRIOR
1. 단순한 게시글의 댓글 조회 쿼리 1 SELECT * FROM REPLY WHERE BNO = 603; cs ------- CLEVEL = 1 댓글 CLEVEL = 2 대댓글 ------- CNO = 댓글번호 CREFNO = 대댓글이 참조하고 있는 댓글 번호 2. START WITH 조건 CONNECT BY PRIOR 자식컬럼 = 부모컬럼; 1 2 3 SELECT * FROM REPLY WHERE BNO = 603 START WITH CLEVEL = 1 CONNECT BY PRIOR CNO = CREFNO; cs 쿼리 결과