34,593
社区成员
发帖
与我相关
我的任务
分享sql语句问题，可以这样写吗？
update table1 set name=case when a.yin>0 then 1 else a.yin
where id=3 select sum(yin) as yin from table1 a where id=3
where id=3 select sum(yin) as yin from table1 a where id=3
...全文
请发表友善的回复…
发表回复
中国风 2006-12-25
- 打赏
- 举报
改一下就可以了
update table1
set name=case when (select sum(yin) from table1 a where id=table1.id)>0 then 1
else select sum(yin) from table1 a where id=table1.id) end
where id=3
update table1
set name=case when (select sum(yin) from table1 a where id=table1.id)>0 then 1
else select sum(yin) from table1 a where id=table1.id) end
where id=3
QQMagicer 2006-12-25
- 打赏
- 举报
也可以这么写
update table1
set name=case when sum(yin)>0 then 1 else sum(yin)
where id=3
update table1
set name=case when sum(yin)>0 then 1 else sum(yin)
where id=3
QQMagicer 2006-12-25
- 打赏
- 举报
update table1
set name=case when a.yin>0 then 1 else a.yin
from table1,(select sum(yin) as yin from table1 where id=3) as a
where id=3
set name=case when a.yin>0 then 1 else a.yin
from table1,(select sum(yin) as yin from table1 where id=3) as a
where id=3
冷箫轻笛 2006-12-25
- 打赏
- 举报
我看是两句
update table1 set name=case when a.yin>0 then 1 else a.yin
where id=3
select sum(yin) as yin from table1 a where id=3
update table1 set name=case when a.yin>0 then 1 else a.yin
where id=3
select sum(yin) as yin from table1 a where id=3
leo_lesley 2006-12-25
- 打赏
- 举报
你写的是几句话
leo_lesley 2006-12-25
- 打赏
- 举报
乱写的
cwlcwr 2006-12-25
- 打赏
- 举报
GZ
