SQL 常用语句

最新推荐文章于 2024-09-21 10:25:52 发布

idomyway

最新推荐文章于 2024-09-21 10:25:52 发布

阅读量507

点赞数

分类专栏：集合专区文章标签： sql table

本文链接：https://blog.csdn.net/idomyway/article/details/120313253

版权

集合专区专栏收录该内容

13 篇文章 0 订阅

订阅专栏

将t1的数据update到t2

update sde.ysyzdxmpp t2
   set t2.djmj =
       (select t.area
          from (select sum(t.shape.area) area, t.bsm from sde.xiangjiaoshuju t group by t.bsm) t
         where t.bsm = t2.bsm)
 where exists (select 1 from (select sum(t.shape.area) area, t.bsm from sde.xiangjiaoshuju t group by t.bsm) t where t.bsm = t2.bsm);