表结构如下: id name type sl 1 v1 a 10 2 v1 a 10 3 v1 b 10 4 v1 b 10type只有两种值,a 或者 b 要求汇总出:v1(a) = 20 , v1(b) = 20 select name,type=sum(type) from 表 group by name,type
---是这个意思吗? select name,type=sum(type) from 表 group by name,type
报错!不能以Nvarchar类型数据作为SUM参数。
這個?Select name, type, SUM(sl) As sl From 表 Group By name, type
select name,type=sum(cast(type as float)) from 表 group by name,type
---是这个意思吗? select name,type=sum(type) from 表 group by name,type---------------- 你怎麼去sum(type)?!
表结构如下: id name type sl 1 v1 a 10 2 v1 a 10 3 v1 b 10 4 v1 b 10type只有两种值,a 或者 b 要求汇总出:v1(a) = 20 , v1(b) = 20 ------------------- select name ,type, sum(cast(s1 as int))as s from t group by name ,type
或者這種格式?Select name, SUM(Case type When 'a' Then sl Else 0 End) As a, SUM(Case type When 'b' Then sl Else 0 End) As b From 表 Group By name
select name ,type, sum(s1) as s from t group by name ,type
select name,type=sum(cast(type as float)) from 表 group by name,type
------------- 沒看錯吧,你是不是受了誤導?'a'轉為float型?!
或者這種格式?Select name, SUM(Case type When 'a' Then sl Else 0 End) As a, SUM(Case type When 'b' Then sl Else 0 End) As b From 表 Group By name-------------------- Yes!就是这种格式!
select name,type, sum(sl)as sl from table1 group by name,type
select sum(case when type='a' then cast(sl as float) end) a_匯總,sum(case when type='b' then cast(sl as float) end) b_匯總,
表结构如下: id name type sl 1 v1 a 10 2 v1 a 10 3 v1 b 10 4 v1 b 10type只有两种值,a 或者 b 要求汇总出:v1(a) = 20 , v1(b) = 20select type , sum(sl) sl from tb group by type
或者這種格式?Select name, SUM(Case type When 'a' Then sl Else 0 End) As a, SUM(Case type When 'b' Then sl Else 0 End) As b From 表 Group By name-------------------- Yes!就是这种格式!
id name type sl
1 v1 a 10
2 v1 a 10
3 v1 b 10
4 v1 b 10type只有两种值,a 或者 b
要求汇总出:v1(a) = 20 , v1(b) = 20
select name,type=sum(type)
from 表
group by name,type
select name,type=sum(type)
from 表
group by name,type
name,
type,
SUM(sl) As sl
From
表
Group By
name,
type
from 表
group by name,type
---是这个意思吗?
select name,type=sum(type)
from 表
group by name,type----------------
你怎麼去sum(type)?!
id name type sl
1 v1 a 10
2 v1 a 10
3 v1 b 10
4 v1 b 10type只有两种值,a 或者 b
要求汇总出:v1(a) = 20 , v1(b) = 20
-------------------
select name ,type, sum(cast(s1 as int))as s from t group by name ,type
name,
SUM(Case type When 'a' Then sl Else 0 End) As a,
SUM(Case type When 'b' Then sl Else 0 End) As b
From
表
Group By
name
select name,type=sum(cast(type as float))
from 表
group by name,type
-------------
沒看錯吧,你是不是受了誤導?'a'轉為float型?!
name,
SUM(Case type When 'a' Then sl Else 0 End) As a,
SUM(Case type When 'b' Then sl Else 0 End) As b
From
表
Group By
name--------------------
Yes!就是这种格式!
select name,type, sum(sl)as sl
from table1
group by name,type
id name type sl
1 v1 a 10
2 v1 a 10
3 v1 b 10
4 v1 b 10type只有两种值,a 或者 b
要求汇总出:v1(a) = 20 , v1(b) = 20select type , sum(sl) sl from tb group by type
正确答案是什么
-----------------回復前不看回復的?
philips933() ( ) 信誉:100 2007-8-4 15:55:43 得分: 0
或者這種格式?Select
name,
SUM(Case type When 'a' Then sl Else 0 End) As a,
SUM(Case type When 'b' Then sl Else 0 End) As b
From
表
Group By
name--------------------
Yes!就是这种格式!
正确答案是什么
-------------又一個不看回貼的.
LZ问的不是这个么?
对name,type分组求和不就成了么?
LZ问的不是这个么?
--------------------------
你也没看回复. :)