简单有效 select distinct exam_id,duration,release_time from( select uid,exam_id,duration,release_time, Nth_value(timestampdiff(second,start_time,submit_time),2) over(partition by exam_id order ...
