27,580
社区成员
发帖
与我相关
我的任务
分享
select min(id)as id,vip_accounts,isnull(max(THprices),0) as THprices,isnull(max(SendGoodsPrice),0) as SendGoodsPrice,isnull(max(balanceMoney),0) as balanceMoney from 表 group by vip_accounts
[/quote]
嗯嗯 是可以了,谢谢啦select min(id)as id,vip_accounts,isnull(max(THprices),0) as THprices,isnull(max(SendGoodsPrice),0) as SendGoodsPrice,isnull(max(balanceMoney),0) as balanceMoney from 表 group by vip_accounts
select max(ID) id,
vip_accounts,
MAX(THprices) THprices,
MAX(SendGoodsPrice) SendGoodsPrice,
MAX(balanceMoney) balanceMoney
from T_isok_order_ALL_Account
where vip_accounts='素素'
group by ID,vip_accounts
[/quote]
嗯 谢谢你的思路,不过需要在max()函数里面放isnull() 其实我也是刚刚知道的 哈哈select min(ID) id,
vip_accounts,
MAX(THprices) THprices,
MAX(SendGoodsPrice) SendGoodsPrice,
MAX(balanceMoney) balanceMoney
from T_isok_order_ALL_Account group by vip_accounts
select max(ID) id,
vip_accounts,
MAX(THprices) THprices,
MAX(SendGoodsPrice) SendGoodsPrice,
MAX(balanceMoney) balanceMoney
from T_isok_order_ALL_Account
where vip_accounts='素素'
group by ID,vip_accounts
select min(id)as id,vip_accounts,max(isnull(THprices,0)) as THprices,max(isnull(SendGoodsPrice,0)) as SendGoodsPrice max(isnull(balanceMoney,0))) as balanceMoney from 表 group by vip_accounts
select id,vip_accounts,max(isnull(THprices,0)) as THprices,max(isnull(SendGoodsPrice,0)) as SendGoodsPrice max(isnull(balanceMoney,0))) as balanceMoney from 表 group by id,vip_accounts
select id,vip_accounts,isnull(THprices,0)+isnull(SendGoodsPrice,0)+isnull(balanceMoney,0) from 表
数值型的可以直接加和select ID,vip_accounts,
MAX(THprices) THprices,
MAX(SendGoodsPrice) SendGoodsPrice,
MAX(balanceMoney) balanceMoney
from T_isok_order_ALL_Account
where vip_accounts='素素'
group by ID,vip_accounts