select 存货分类,sum(销售数量) as 销售合计 from 表1 group by 存货分类
select 存货分类,销售合计=sum(销售数量) from 表1 group by 存货分类 order by 存货分类
select 存货分类,销售合计=sum(销售合计) from 表1 group by 存货分类
select 存货分类,sum(销售数量) as 销售合计 from 表1 group by 存货分类 order by 存货分类
搞错了, 不好意思. 结果集应该如下:存货分类 A B C -------------------------------- 销售合计 1700 400 1500 加记录后, 结果为存货分类 A B C D ------------------------------------------ 销售合计 1700 400 1500 600
搞错了, 不好意思. 结果集应该如下:存货分类 A B C -------------------------------- 销售合计 1700 400 1500 加记录后, 结果为存货分类 A B C D ------------------------------------------ 销售合计 1700 400 1500 600
又如果在上述表1新增一记录 ------------------------- 这句话以下的内容不影响SQL语句的正确执行:select 存货分类,sum(销售数量) as 销售合计 from 表1 group by 存货分类
--查询 declare @s varchar(8000) set @s='' select @s=@s+',['+存货分类+']=sum(case 存货分类 when '''+存货分类+''' then 销售数量 else 0 end)' from 表1 group by 存货分类 set @s=stuff(@s,1,1,'') exec('select '+@s+' from 表1')
select 存货分类,sum(销售数量) as 销售合计 from 表1 group by 存货分类
group by 存货分类
order by 存货分类
select 存货分类,销售合计=sum(销售合计)
from 表1
group by 存货分类
from 表1
group by 存货分类
order by 存货分类
--------------------------------
销售合计 1700 400 1500
加记录后, 结果为存货分类 A B C D
------------------------------------------
销售合计 1700 400 1500 600
--------------------------------
销售合计 1700 400 1500
加记录后, 结果为存货分类 A B C D
------------------------------------------
销售合计 1700 400 1500 600
-------------------------
这句话以下的内容不影响SQL语句的正确执行:select 存货分类,sum(销售数量) as 销售合计 from 表1 group by 存货分类
declare @s varchar(8000)
set @s=''
select @s=@s+',['+存货分类+']=sum(case 存货分类 when '''+存货分类+''' then 销售数量 else 0 end)'
from 表1
group by 存货分类
set @s=stuff(@s,1,1,'')
exec('select '+@s+' from 表1')