postgres两张表关联查询，去重复部分，要借助临时表

with temp_statue as 
(
    select user_id, max(start_time) max_start_time
    from l
    where start_time + interval '7200 second' > now() and lat is not null and lng is not null
    group by user_id
)
select l.user_id, l.start_time, l.lat, l.lng,  l.azimuth_angle, l.device_status,  u.first_name 
from   temp_statue
inner join statue_log l
on         l.user_id = temp_statue.user_id
and        l.start_time = temp_statue.max_start_time
inner join base_user u on temp_statue.user_id = u.id;

要是其他数据库sql，修改时间就可以

查询一个结果集，再执行相关路径