--最后复职后首次调动 select a.userid,a.name,a.Rtime --,rank() over(partition by a.Rtime order by a.userid) as rank ,row_number() over(partition by a.userid,a.name order by a.Rtime) as rownum from Userreainfo as a left join Restorationinfo as b on a.userid=b.userid --where a.userid=33729 group by a.userid,a.name,a.Rtime having a.Rtime > max(b.Restorationdate)-- and a.Rtime=min(a.Rtime)