ACCESS表求和?
SELECT [編號(hào)],[金額],[數(shù)量],SUM([金額]*[數(shù)量]) as [合計(jì)]from [表名]group by [編號(hào)],[金額],[數(shù)量]
上一篇什么樣的天氣最適合釣鯉魚
下一篇流量是怎樣計(jì)算的
ACCESS表求和?
SELECT [編號(hào)],[金額],[數(shù)量],SUM([金額]*[數(shù)量]) as [合計(jì)]from [表名]group by [編號(hào)],[金額],[數(shù)量]