告诉你个高级点的方法，用开窗函数
select * from
(
select id,fid,time,name,rank()over(partition by fid order by time desc) mm from a
)
where mm=1
select a.* from a,(select fid,max(time) time from a group by fid) b
where a.fid=b.fid and a.time=b.time
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024