TRANSFORM Sum(XiaoShouDan2.ChanPinJE) AS BB
SELECT XiaoShouDan2.DanWei
FROM XiaoShouDan2
GROUP BY XiaoShouDan2.DanWei
PIVOT XiaoShouDan2.ChanPinID;
上面是一个ACCESS交叉表查询语句,如果我想在最后一列和最后一行加上合计,语句应该怎么写?
另MS Server2000的交叉表语句是怎样写的?
...全文
234打赏收藏
交叉表SQL语句问题?
TRANSFORM Sum(XiaoShouDan2.ChanPinJE) AS BB SELECT XiaoShouDan2.DanWei FROM XiaoShouDan2 GROUP BY XiaoShouDan2.DanWei PIVOT XiaoShouDan2.ChanPinID; 上面是一个ACCESS交叉表查询语句,如果我想在最后一列和最后一行加上合计,语句应该怎么写? 另MS Server2000的交叉表语句是怎样写的?
这个简单,行的语句你自己用函数搞定就可以了,我不知道你对哪些求和,一个思路如下如
select a,b,c, a+b+c as 合计 from table
union sum(a) as a ,sum(b) as b ,sum(c) as c ,sum(a)+sum(b)+sum(c) as 合计 from table