반응형 range1 오라클) 윈도우 함수(Window Function)의 FIRST_VALUE(), LAST_VALUE() 예시 FIRST_VALUE(컬럼명): 컬럼의 첫번째 값LAST_VALUE(컬럼명): 컬럼의 마지막 값 SELECT EMPLOYEE_ID ,DEPARTMENT_ID ,SALARY ,FIRST_VALUE(SALARY) IGNORE NULLS OVER (PARTITION BY DEPARTMENT_ID ORDER BY SALARY) AS LOW_SAL ,LAST_VALUE(SALARY) IGNORE NULLS OVER (PARTITION BY DEPARTMENT_ID ORDER BY SALARY) AS HIGH_SAL_1 ,LAST_VALUE(SALARY) IGNORE NULLS OVER (PARTITION BY DEPARTMENT_ID ORDER BY SALARY .. 2024. 8. 26. 이전 1 다음 반응형
