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数据表
最新推荐文章于 2024-07-17 15:36:13 发布
update t1 set (t1.LONGITUDE,t1.LATITUDE) = (select t.LATITUDE,t.LONGITUDE from GPSDATA t where t.LATITUDE > 100 AND t.GUID = t1.GUID)