为什么这样写不行呢? 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
点赞

相关推荐

牛客网
牛客企业服务