我目前正在为此SQL语句的逻辑而苦苦挣扎。
我有一个表,其中的列包含:
Country, Customer, Year, Product Purchased( 5 different products) and Revenue.
我希望写一个选择声明,其中拉出国家/地区、客户名称、购买的每种产品、每年客户每种产品的收入。
SELECT Country, Customer, Year, Product, Revenue
FROM table
GROUP BY Country, Customer, Year, Product Purchased, Revenue
国家 客户年份 产品收入 总收入 英格兰客户 A 2017 产品 A 100 200 英格兰客户 A 2017 产品 B 100 200 英国客户 A 2016 产品 A 100 100 谁能帮忙?
SELECT sum(Revenue), Country, Customer, Year, Product
FROM table
GROUP BY Country, Customer, Year, Product
现场演示以说明结果
SELECT SUM(Revenue),Country, Customer, YEAR, Product
FROM TABLE
GROUP BY Country, Customer, YEAR, Product Purchased