dipesh.ccsu
Starting Member
7 Posts |
Posted - 2013-04-26 : 11:30:17
|
BELOW IS MY SQL. Not sure why i am getting the error(selected non-aggregate values must be part of the associated group ERROR) but i believe it is in my where clauses. Can anyone help.CREATE TABLEuser_tbls.DD2_97_HI AS (SELECT DA.CHNGE_DT, DA.Acct_No, DA.SB, DA.PR, DA.PRD, DA.BIL, DA.BILL_SU, DA.PR, DA.PRD_GRP, DA.PRD_FA, DA.NATRL_AC, DA.Balance_T, SUM(DA.Total_Ac) AS Total_Activations, SUM(DA.De) AS Deactivations, SUM(DA.U) AS Upgrades, SUM(DA.D) AS Downgrades, SUM(DA.Si) AS Sidegrades, SUM(DA.Mi) AS Migrations, SUM(DA.M) AS Moves, SUM(DA.Ne) AS Net_Miscellaneous, SUM(DA.Net_Act) AS Net_Activations FROM sort.SC_DAY_AY_V DAWHERE (DA.CHNGE_DT, DA.Acct_No) IN (SELECT MIN(CHNGE_DT), ACCT_NO FROM finance_user_tbls.DDC582_976_NRC_CODES_ACT)AND DA.Prd_Grp2_Type_Ds = 'HSI'AND DA.Balance_To_Essbase = 'Y'GROUP BY 1,2,3,4,5,6,7,8,9,10,11,12)WITH DATAPRIMARY INDEX (CHNGE_DT,SB, PRD) |
|