elect
商品名,
买 = sum(case [买/卖] when 'B' then 数量 else 0 end),
卖 = sum(case [买/卖] when 'S' then 数量 else 0 end)
from
表名
group by
商品名
商品名,
买 = sum(case [买/卖] when 'B' then 数量 else 0 end),
卖 = sum(case [买/卖] when 'S' then 数量 else 0 end)
from
表名
group by
商品名
商品名,
买 = sum(case [买/卖] when 'B' then 数量 else 0 end),
卖 = sum(case [买/卖] when 'S' then 数量 else 0 end)
from
表名
group by
商品名
商品名,
[买] = sum(case [买/卖] when 'B' then 数量 else 0 end),
[卖] = sum(case [买/卖] when 'S' then 数量 else 0 end)
from
表名
group by
商品名