我有一个MS Access项目,我想从一个表中生成一个报告。我不太确定这是否可以做到。
以下是源表
Name Fruits Count
Jorge Apple 4
Jorge Mango 3
Jorge Pears 4
Jorge Pineapple 6
James Apple 8
James Mango 1
James Pears 4
James Pineapple 6我想要一个连续形式的结果
Name Apple Mango Pears Pineapple
Jorge 4 3 4 6
James 8 1 4 6SQL能做到这一点吗?
发布于 2020-06-10 20:51:34
试试这个:
TRANSFORM sum(MyTable.count) AS noOfCount
SELECT MyTable.name
FROM MyTable
GROUP BY MyTable.name
PIVOT MyTable.fruits;发布于 2020-06-10 20:44:58
您可以使用条件聚合。在MS Access中,如下所示:
select name,
sum(iif(fruit = "Apple", 1, 0)) as apple,
sum(iif(fruit = "Mango", 1, 0)) as mango,
sum(iif(fruit = "Pear", 1, 0)) as pear,
sum(iif(fruit = "Pineapple", 1, 0)) as pineapple
from t
group by name,https://stackoverflow.com/questions/62303865
复制相似问题