题解 | 每篇文章同一时刻最大在看人数
每篇文章同一时刻最大在看人数
https://www.nowcoder.com/practice/fe24c93008b84e9592b35faa15755e48
select artical_id, max(nowview) max_uv from ( select artical_id, dt , sum(diff) over(partition by artical_id order by dt ,diff desc) nowview from( seLECT artical_id,in_time dt, 1 diff from tb_user_log union all seLECT artical_id,out_time dt, -1 diff from tb_user_log )t )t1 where artical_id !=0 group by artical_id order by max_uv desc
查看12道真题和解析