求一SQL语句! 你的结果对吗?select name,sum(nums) nums ,sum(price) price from table group by name 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 哦,楼主的意思是否是 nums*price?那样的话应该是select name,sum(nums) nums ,sum(price*nums) price from table group by name select a.*,(a.num*b.price) as pricefrom(select name,sum(nums) as numfrom table1 group by name,nums) a,table1 bwhere a.name=b.name --建立测试环境declare @table1 table(autoid int,name varchar(10),nums int,price decimal(5,1))insert into @table1 select 1,'aaa',2,2.2 unionselect 2,'bbb',3,1.1 unionselect 3,'ccc',1,2.0 unionselect 4,'aaa',1,2.2--查询select name,sum(nums)nums,sum(nums*price)price from @table1 group by name--结果name nums price ---------- ----------- ---------------------------------------- aaa 3 6.6bbb 3 3.3ccc 1 2.0(所影响的行数为 3 行) 建一个院系表 取得记录总数的错误? inserted 的疑问 新手求一个查找同名用户的sql语句,自己吭哧了好长时间硬是没想出来,大哥们帮帮忙 如何移植数据库? 请教多表查询结果按日期求和? 为什么不能创建这条存储过程? 求高手帮忙在线等! 球一个查询语句 sql 的奇怪错误 送100分,请教如何建立一个与某已存在表同结构的表? 【急】日期查询问题 枫兮在马?????枫兮在马?????
那样的话应该是
select name,sum(nums) nums ,sum(price*nums) price from table group by name
from(select name,
sum(nums) as num
from table1 group by name,nums) a,table1 b
where a.name=b.name
--建立测试环境
declare @table1 table(
autoid int,
name varchar(10),
nums int,
price decimal(5,1)
)
insert into @table1
select 1,'aaa',2,2.2 union
select 2,'bbb',3,1.1 union
select 3,'ccc',1,2.0 union
select 4,'aaa',1,2.2
--查询
select name,sum(nums)nums,sum(nums*price)price from @table1 group by name
--结果
name nums price
---------- ----------- ----------------------------------------
aaa 3 6.6
bbb 3 3.3
ccc 1 2.0(所影响的行数为 3 行)