题解 | 骑行运动社区路线个人最佳排名
骑行运动社区路线个人最佳排名
https://www.nowcoder.com/practice/9a7bde8872dd41268e0c69b2d5cd4c42
select route_name ,distance_km ,rider_name ,ride_date ,completion_min ,avg_speed_kmh from cycling_routes as a left join lateral (select * from (select b.*,row_number() over(partition by rider_name order by completion_min,ride_date,ride_id desc) as rn from ride_records as b ) as cc where a.route_id=cc.route_id and cc.rn=1 order by completion_min limit 2 )as dd on true
查看3道真题和解析