sum 求和问题,再次求解!

2007-08-17 08:21:28 339 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

C# 枚举（Enum）枚举是一组命名整型常量。枚举类型是使用 enum 关键字声明的。C# 枚举是值类型。枚举是一组命名整型常量。枚举类型是使用关键字声明的。C# 枚举是值类型。换句话说，枚举包含自己的值，且不能继承或传递继承。阅读详情

有如下视图： jhview (goodsID,goodsNAME,goodsSL,goodsDJ,goodsJE,riqi)

记录有如下：
goodsID goodsNAME goodsSL goodsDJ goodsJE goodsGG riqi
1 钢笔 20 2 40 长城牌 2004-12-15
1 钢笔 20 2 40 长城牌 2005-12-05
2 笔记本 30 1 30 大号 2005-12-15
3 铅笔 20 1 20 长细 2005-12-20
4 钢笔 10 4 40 英雄牌 2005-12-25

现在想计算sum(goodsSL),sum(goodsJE)且过滤goodsID 的重复项
即得出sum(goodsSL),sum(goodsJE),名字相同的物品它们的ID号(goodsID)和规格 (goodsGG)不相同.现在要显示如下视图:
goodsID goodsNAME goodsSL goodsJE goodsGG
1 钢笔 40 80 长城牌
2 笔记本 30 30 大号
3 铅笔 20 20 长细
4 钢笔 10 40 英雄牌

请帮忙写出语句谢谢!

...全文

SAP PS项目结算实操：从CJ20N到CJ88，手把手搞定项目成本结转与凭证生成本文详细解析SAP PS项目结算全流程，从CJ20N到CJ88的操作要点，涵盖成本归集、结算规则配置、结果分析及凭证生成等关键环节。特别针对FICO模块中的项目凭证流转问题提供实战解决方案，帮助财务人员规避常见配置错误，提升项目结算效率与准确性。阅读详情

sione88

应用实例 27,579 成员 68,540 内容

+ 关注 + 加入社区

切换为时间正序

divmedia 2007-08-24

打赏
举报

select
goodsID,
goodsNAME,
sum(goodsSL),
sum(goodsJE ),
goodsGG
from jhview
group by goodsID,goodsNAME,goodsGG

divmedia 2007-08-24

打赏
举报

select goodsID , goodsNAME , sum(goodsSL) , sum(goodsJE ) , goodsGG
from jhview group by goodsID

CodeMoving 2007-08-24

打赏
举报

select a.goodsID,b.goodsName,a.sum(goodsSl),a.sum(goodsJE),b.goodsGG from (select goodsID,sum(goodsSl),sum(goodsJE) from jhview ) a left join jhview b on a.goodsID=b.goodsID

anison 2007-08-23

打赏
举报

select goodsID,goodsName,goodsSL=sum(goodsSL),goodsJE=sum(goodsJE),goodsGG from jhview group by goodsID,goodsName,goodsGG

zs621 2007-08-23

打赏
举报

select goodsID , goodsNAME , sum(goodsSL) , sum(goodsJE ) , goodsGG
from jhview group by goodsID

fckadxz 2007-08-18

打赏
举报

--这种写法有新意哟，既然楼主开了贴，多写个方案讨论一下。
select goodsID , min(goodsNAME),sum(goodsSL), sum(goodsJE ) ,min(goodsGG)
from jhview group by goodsID

pastbee 2007-08-17

打赏
举报

这问题散分的吧,我来接分

mysky0103 2007-08-17

打赏
举报

对了又写错了

select goodsID , goodsNAME , sum(goodsSL) , sum(goodsJE ) , goodsGG
from jhview group by goodsID,goodsNAME,goodsGG 应该这样 ,不好意思啊

OracleRoob 2007-08-17

打赏
举报

create table #jhview (goodsID int,goodsNAME varchar(100),goodsSL int,goodsDJ int,goodsJE int,goodsGG varchar(100),riqi datetime)

insert into #jhview select 1,'钢笔',20,2,40,'长城牌','2004-12-15'
insert into #jhview select 1,'钢笔',20,2,40,'长城牌','2005-12-05'
insert into #jhview select 2,'笔记本',30,1,30,'大号','2005-12-15'
insert into #jhview select 3,'铅笔',20,1,20,'长细','2005-12-20'
insert into #jhview select 4,'钢笔',10,4,40,'英雄牌','2005-12-25'

select
goodsID,
goodsNAME,
sum(goodsSL) as goodsSL,
sum(goodsJE ) as goodsJE,
goodsGG
from #jhview
group by goodsID,goodsNAME,goodsGG

drop table #jhview

OracleRoob 2007-08-17

打赏
举报

--改下
select
goodsID,
goodsNAME,
sum(goodsSL),
sum(goodsJE ),
goodsGG
from jhview
group by goodsID,goodsNAME,goodsGG

OracleRoob 2007-08-17

打赏
举报

select
goodsID,
goodsNAME,
sum(goodsSL),
sum(goodsJE ),
goodsGG
from jhview
group by goodsID

mysky0103 2007-08-17

打赏
举报

select goodsID , goodsNAME , sum(goodsSL) , sum(goodsJE ) , goodsGG
from jhview group by goodsID

sum 求和问题,再次求解!

相关推荐