제품별 FROM TO 날짜를 구하려고 합니다.
WITH T(PROD_CODE, DT) AS ( SELECT 'A1','20120101' FROM DUAL UNION ALL SELECT 'A2','20120501' FROM DUAL UNION ALL SELECT 'A3','20121201' FROM DUAL UNION ALL SELECT 'B1','20120301' FROM DUAL UNION ALL SELECT 'B2','20120601' FROM DUAL UNION ALL SELECT 'C1','20120701' FROM DUAL UNION ALL SELECT 'C2','20120801' FROM DUAL UNION ALL SELECT 'C3','20121001' FROM DUAL UNION ALL SELECT 'C4','20121201' FROM..
더보기
구간에서 원하는 결과값 구하기
특정구간을 통해서 결과값 구하기 ==================================== SELECT A.JUMSU, VALUE1, VALUE2 FROM ( WITH T AS ( SELECT 10 JUMSU, '0' AS VALUE FROM DUAL UNION ALL SELECT 7 , '2500' FROM DUAL UNION ALL SELECT 8 , '1000' FROM DUAL UNION ALL SELECT 6 , '1500' FROM DUAL UNION ALL SELECT 3 , '2000' FROM DUAL) SELECT JUMSU, VALUE VALUE1, NVL(LEAD(VALUE) OVER (ORDER BY VALUE),'9999') VALUE2 FROM T ORDER BY VAL..
더보기