UC知道请教：这段SQL语句是什么意思？
来源：百度知道 编辑：UC知道 时间：2024/07/04 10:26:40
select sum(Quantity) as Quantity,0 as AccountQty,GoodsCode
into #A2
from inv_tb_CheckDetail_pdcg group by GoodsCode
into #A2
from inv_tb_CheckDetail_pdcg group by GoodsCode
select sum(Quantity) as Quantity, --对Quantity字段求和 命名为Quantity
0 as AccountQty,GoodsCode --检索两个字段
into #A2 --插入新表
from inv_tb_CheckDetail_pdcg --从哪个表
group by GoodsCode --以字段GoodsCode分组
sum(Quantity) 求和
into #A2 把查询到的结果写入新表 #A2
把inv_tb_CheckDetail表按GoodsCode分组，选出quantity总和，赋值给变量#A2,数字0，GooldsCode，三个字段显示出来