mysql 累加函数：sum(x) over(partition by y order by z)

注意时间相减用TIMASTAMPDIFF函数 法一 select tag,concat(round(avg(watch_time*1.0/duration)*100,2),'%') avg_play_progress from (select tag,duration, case when timestampdiff(second,start_time,end_time)>duration then duration else timestampdiff(second,start_time,end_time) end watch_time from tb_user_video_log...