select frcst.MFG_ORG_CD
, frcst.RTL_ORG_CD
, frcst.ORG_BSNS_UNIT_ID
, frcst.MFG_SKU_ITEM_ID
, frcst.RTL_SKU_ITEM_ID
, frcst.DAY_CD
, frcst.FRCST_PURP
, frcst.FRCST_TYP
, max(frcst.FRCST_VRSN) as MAX_FRCST_VRSN
, count(*) as CNT_TOTAL
from DDR_B_SLS_FRCST_ITEM_DAY frcst
group by frcst.MFG_ORG_CD
, frcst.RTL_ORG_CD
, frcst.ORG_BSNS_UNIT_ID
, frcst.MFG_SKU_ITEM_ID
, frcst.RTL_SKU_ITEM_ID
, frcst.DAY_CD
, frcst.FRCST_PURP
, frcst.FRCST_TYP
SELECT FRCST.MFG_ORG_CD
, FRCST.RTL_ORG_CD
, FRCST.ORG_BSNS_UNIT_ID
, FRCST.MFG_SKU_ITEM_ID
, FRCST.RTL_SKU_ITEM_ID
, FRCST.DAY_CD
, FRCST.FRCST_PURP
, FRCST.FRCST_TYP
, MAX(FRCST.FRCST_VRSN) AS MAX_FRCST_VRSN
, COUNT(*) AS CNT_TOTAL
FROM DDR_B_SLS_FRCST_ITEM_DAY FRCST
GROUP BY FRCST.MFG_ORG_CD
, FRCST.RTL_ORG_CD
, FRCST.ORG_BSNS_UNIT_ID
, FRCST.MFG_SKU_ITEM_ID
, FRCST.RTL_SKU_ITEM_ID
, FRCST.DAY_CD
, FRCST.FRCST_PURP
, FRCST.FRCST_TYP
|
|
|