思路和大家的差不多,但是中间出了一个问题,标注一下,提醒一下自己下次注意。刚开始写的时候这样的 错误的sql WITH t1 AS ( SELECT artical_id,in_time dt,1 diff FROM tb_user_log WHERE artical_id <> 0 UNION SELECT artical_id,out_time dt,-1 diff FROM tb_user_log WHERE artical_id <> 0 ), t2 as( SELECT artical_id, sum(diff) over(PARTITION ...