3,491
社区成员
发帖
与我相关
我的任务
分享
select b.* from
(
select * from A where state=2
)A
left join
(
select *,row_number()over(partition by end_link order by date desc) rn from A where state=1
)B
on A.start_link=B.end_link
where A.id=5
and b.rn=1
加一个rn列,筛选rn=1的
Row_Number() Over(Partition By Order By )