题解 | 被重复观看次数最多的3个视频
被重复观看次数最多的3个视频
https://www.nowcoder.com/practice/b75fa2412659422c96369976ee1f9504
with t1 as(select cid,uid,count(*) as times from play_record_tb group by cid,uid having count(*)>=2) select * from ( select c.cid,pv,row_number() over(order by pv desc,release_date desc)as rk from( select cid,sum(times) as pv from t1 group by cid)c left join course_info_tb b on c.cid=b.cid)d where rk<=3
深信服公司福利 816人发布