SELECT MAX(loc_time), executor_id AS objId, longitude, latitude, longitude_sj, latitude_sj
FROM r_inspection_executetrail rie
WHERE longitude IS NOT NULL AND latitude IS NOT NULL
AND longitude != ‘0.0’ AND latitude != ‘0.0’
AND executor_id IN (‘e2449c56d98448a491f63c3952383da3’)
GROUP BY executor_id;这是查询语句,除了时间是 datetime,其他都是varchar