UPDATE ${目标表} a
INNER JOIN (
SELECT gridid,
deviceid,
ROUND( max( o3_8 ), 2 ) o3_8,
#{beginTime} avgdate
FROM ${数据来源表}
WHERE avgdate > #{beginTime}
AND avgdate <= #{endTime}
GROUP BY deviceid
) AS b ON a.deviceid = b.deviceid AND a.avgdate = b.avgdate
SET a.o3_8 = b.o3_8