题解 | 被重复观看次数最多的3个视频
被重复观看次数最多的3个视频
https://www.nowcoder.com/practice/b75fa2412659422c96369976ee1f9504
select a.cid,
cast(pv as decimal(10,3)),
row_number()over(order by pv desc,b.release_date desc) as rk
from (
select cid,
count(1) as pv
from play_record_tb
group by uid,cid
) a
join course_info_tb b on a.cid = b.cid
where pv>1
order by pv desc
limit 3
先处理各自的表格内容，然后在进行最后的合并操作
美的集团公司福利 717人发布