i need to group by and sum to specific col

Abdalla Elawad

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 .

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manav Pandya8y ago
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
Abdalla Elawad8y ago
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 Elawad8y ago
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
Manav Pandya8y ago
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