to:qiozi(【天生反对派】)
唉,我自己的没有实现,你的想到一种办法,不太完善,以下在access中验证通过,在sqlserver中需改成相应的函数名。
select "本月" as statstate,sum(iif(objectClass='武侠',price,0)) as 武侠,sum(iif(objectClass='言情',price,0)) as 言情,sum(iif(objectClass='杂志',price,0)) as 杂志,sum(iif(objectClass='电脑',price,0)) as 电脑 from 表名 where month([date])=month(now()) union select "全部" as statstate,sum(iif(objectClass='武侠',price,0)) as 武侠,sum(iif(objectClass='言情',price,0)) as 言情,sum(iif(objectClass='杂志',price,0)) as 杂志,sum(iif(objectClass='电脑',price,0)) as 电脑 from 表名