오라클 쿼리문을 mssql로 변경하려고 합니다.
SELECT LEVEL, SEQ_NO, NAME, ID, EMAIL, TITLE, DATE,
HIT_COUNT
FROM (SELECT LEVEL, SEQ_NO, NAME, ID, EMAIL, TITLE,
DATE,
HIT_COUNT, REF_SEQ_NO
FROM QNA
WHERE SEQ_NO IS NOT NULL
ORDER BY SEQ_NO DESC)
START WITH REF_SEQ_NO IS NULL AND SEQ_NO > 0 CONNECT BY
PRIOR SEQ_NO = REF_SEQ_NO AND SEQ_NO > 0
|