sql多表查询当id相同时取时间最大的条数

[海洋秋风]

如图当id相同时取occur_time时间最大的那条
select
b.id ,
b.psid ,
a.id,
a.name,
j.name,
e.status,
e.occur_time,
f.user_name,
e.feeder_id
from d5000.dms_cb_device a
left join d5000.dms_send_dc b
on long2_to_long1(b.psid)=a.id
left join d5000.dms_dev_term_rel c
on a.id = c.dev_id
left join d5000.dms_terminal_info d
on c.term_id = d.id
left join alarm.dms_op_ctrl e
on e.meas_id = b.psid
left join d5000.sys_priv_user_d_def f
on f.user_id = e.user_id
left join d5000.dms_combined_device j
on j.id = a.combined_id
where b.index_no>-1 and c.if_stat_static = 1 and e.status='7' order by e.occur_time desc

[chengangcsdn]

select id,.....,max(time) from table group by id,.... 就OK了啊。

[八零八零_杨]

我也是小白 ，我的处理方法就是 先 ROW_NUMBER() over(partition by id order by occur_time des )编号 r然后取 编号为1的 那条~~~