为什么这样写不行呢? select round(avg(sum(TIMESTAMPDIFF(second,in_time,out_time)) over partition by uid),1) as avg_viiew_len_sec, date(in_time) as dt from tb_user_log group by dt order by avg_viiew_len_sec desc
点赞

相关推荐

点赞 评论 收藏
分享
ResourceUtilization:四六级不愧是大学最有用的证之一
点赞 评论 收藏
分享
牛客网
牛客企业服务