ROW_NUMBER ORA-00904 서브쿼리에러

Question

SELECT (대략 아래같은 형태인데 서브쿼리에 서브쿼리라 인식을 못하는것 같은데 어떻게 해야할까요 SELECT STR FROM ( SELECT ROW_NUMBER() OVER(PARTITION BY NO ORDER BY DATE ASC, TIME ASC) AS RN, DECODE(B.SE,'I','ERROR',B.DATE||B.TIME) STR FROM DUAL B WHERE B.YEAR&#61;A.YEAR AND B.NO&#61;A.NO AND B.DATE||B.TIME > A.DATE||A.TIME ) WHERE RN&#61;1 ) DT FROM DUAL A WHERE A.YEAR&#61;'2020' ORDER BY A.NO, A.DATE, A.TIME

쿠잉 · Answer

ROW_NUMBER() OVER(PARTITION BY NO ORDER BY DATE ASC, TIME ASC) AS RN, ORA-00904 에러 가 NO 에서 나는거 아닌가요?

ROW_NUMBER ORA-00904 서브쿼리에러

1개의 답변

#subquery 목록