問題描述

現(xiàn)有兩張表，A是明細(xì)表id uid cost

0

1

4

3

現(xiàn)在要把把該表中cost大于0的數(shù)據(jù)，根據(jù)uid分組然后更新到另一個(gè)表上

select uid,count(cost) as count from A group by uid where cost > 0

這是取出的語(yǔ)句，有沒辦法一句話把這個(gè)查詢結(jié)果根據(jù)uid更新到另一張表上？

問題解答

update B b set b.col=(select count(a.cost) as count from A a where cost > 0 and a.uid=b.uid group by uid)