제품별 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..
더보기