게시판 공지사항 고정 기능 때문에 union all을 쓰려는데요

Question

쿼리만 돌렸을 때는 조회가 잘 됐어요근데 dao에 넣고 게시판 조회를 하니까ORA-00933: SQL command not properly ended가 뜨면서 안되네요ㅜ뭘 수정해야 될까요String board_list_sql &#61; &#34;select rownum rnum, j.* &#34;&#43; &#34; from (SELECT BOARD.*, NVL(CNT, 0) AS CNT &#34;&#43; &#34; FROM BOARD LEFT OUTER JOIN (SELECT B_COMMENT_NUM, COUNT(*) CNT FROM BOARD_COMMENT &#34;&#43; &#34; GROUP BY B_COMMENT_NUM) &#34;&#43; &#34; ON BOARD_NUM &#61; B_COMMENT_NUM &#34;&#43; &#34; WHERE BOARD_NOTICE &#61; Y &#34;&#43; &#34; ORDER BY BOARD_RE_REF DESC, &#34;&#43; &#34; BOARD_RE_SEQ ASC &#34;&#43; &#34; ) j &#34;&#43; &#34; where rownum<&#61; 3) &#34;&#43; &#34;UNION ALL &#34;&#43; &#34;selectfrom(select rownum rnum, j. &#34;&#43; &#34; from (SELECT BOARD.*, NVL(CNT, 0) AS CNT &#34;&#43; &#34; FROM BOARD LEFT OUTER JOIN (SELECT B_COMMENT_NUM, COUNT(*) CNT FROM BOARD_COMMENT &#34;&#43; &#34; GROUP BY B_COMMENT_NUM) &#34;&#43; &#34; ON BOARD_NUM &#61; B_COMMENT_NUM &#34;&#43; &#34; WHERE BOARD_NOTICE &#61; N &#34;&#43; &#34; ORDER BY BOARD_RE_REF DESC, &#34;&#43; &#34; BOARD_RE_SEQ ASC &#34;&#43; &#34; ) j &#34;&#43; &#34; where rownum<&#61; ?) &#34;&#43; &#34;where rnum>&#61;? and rnum<&#61;? &#34;;

Clickin · Answer

쿼리 괄호가 이상한데 어떻게 돌아가나요...??union all 밑의 쿼리는 뭘 select 하는지도 없고... union all 하면 컬럼도 맞춰줘야하는데 그것도 없네요

마스터key · Answer

쿼리 자체가 오타도 많네요

게시판 공지사항 고정 기능 때문에 union all을 쓰려는데요

2개의 답변

Q&A 목록