帮忙看下类似这样一个表如何更新 Select cl1,sum(cl2) as cl2,sum(cl3) as cl3 from tbgroup by cl1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Select cl1,sum(cl2) as cl2,sum(cl3) as cl3 from tb group by cl1order by cl1 Select cl1,sum(cl2) as cl2,sum(cl3) as cl3 from tbgroup by cl1 select cl1 , cl2 = sum(cl2) , cl3 = sum(cl3) from tb group by cl1 --updateupdate tbset cl2 = t.cl2, cl3 = t.cl3from tb,(select cl1 , cl2 = sum(cl2) , cl3 = sum(cl3) from tb group by cl1) twhere tb.cl1 = t.cl1 sql 获得某个区间的随机整数 在线等,怎能取出一个字段最大的单号,需要用substring和max函数 vc ado sql 访问问题 求今日排行? 触发器和存储过程 如何让此语句 update tb_state_1 set sta_id="A"+sta_id 正确运行 远程修改sqlserver2000可以吗? 问一个简单的查询语句 全文检索的问题,formsof为什麽不起作用? sql 约束问题 困扰了好久了,条件语句难题求解 sqlserver package里面临时表报错
from tb
group by cl1
order by cl1
Select cl1,sum(cl2) as cl2,sum(cl3) as cl3
from tb
group by cl1
set cl2 = t.cl2,
cl3 = t.cl3
from tb,(select cl1 , cl2 = sum(cl2) , cl3 = sum(cl3) from tb group by cl1) t
where tb.cl1 = t.cl1