i need to group by and sum to specific col

Question

hi guys pls help me i need to create query by group by and sum to specific columns and excute by where cluase like enter Country , please see the TBL Thanks .

Manav Pandya · Answer

Hello Yes sir you can do as much as need I have just executed to show how to do that Can modify as per your requirement Like : select Sum(Column 1) , Sum(Column 2) , Sum(Column 3) , // other values you want where search_variable = its_value Group by column 1 , column 2 , column 3 , I dont have complete table and data like you have so try it by your own Thanks

Manav Pandya · Answer

Hello You can try following simple Group by query select D.year , D.country , SUM(D.sum) as TotalSUM from Demo D group by D.year,D.country And output will be like : let me know if u need more help Thanks

Abdalla Elawad · Answer

like this : but i need to pass one parameter (country) and display all years SELECT Data.COUNTRY_DESC_AR, Data.TRD_YR, Data.CC_CODE, Sum(Data.VALUE) AS SumOfVALUE, Sum(Data.WEIGHT) AS SumOfWEIGHT, Sum(Data.QTY) AS SumOfQTY FROM Data WHERE (((Data.COMMODTIY_CODE) Like [Enter Commdity Code:])) GROUP BY Data.COUNTRY_DESC_AR, Data.TRD_YR, Data.CC_CODE HAVING (((Data.COUNTRY_DESC_AR)=[Enter Country Name:]) AND ((Data.TRD_YR)=[Enter Year:]) AND ((Data.CC_CODE)=[Enter CC Code:]));

Abdalla Elawad · Answer

Thank You MR Manav i need to bulid like this , select to following columns : TRD_YR COUNTRY_DESC_EN CC_CODE COMMODTIY_CODE VALUE WEIGHT QTY from Data ( This is table name ) okay 1. i need to search by COUNTRY_DESC_EN 2. sum fields (VALUE) , (WEIGHT) , (QTY) 3. GROUP BY CC_CODE 4. GROUP BY COMMODTIY_CODE ( I search like to first two digits (04) (07) etc..) 6.GROUP BY TRD_YR I need to summerize query to any country to every year i will attached file excel as given requirements