update t1 set (t1.LONGITUDE,t1.LATITUDE) = (select t.LATITUDE,t.LONGITUDE from GPSDATA t where t.LATITUDE > 100 AND t.GUID = t1.GUID)
oracle 从select的结果update数据表
最新推荐文章于 2023-06-06 09:32:17 发布
update t1 set (t1.LONGITUDE,t1.LATITUDE) = (select t.LATITUDE,t.LONGITUDE from GPSDATA t where t.LATITUDE > 100 AND t.GUID = t1.GUID)