题解 | #第二快/慢用时之差大于试卷时长一半的试卷#
https://www.nowcoder.com/practice/b1e2864271c14b63b0df9fc08b559166
有大神能给看看下面这段为什么一直显示空白呀，没有什么错误就是没有输出正确答案😥看了半天也没看出来个所以然😥😔
select ei.exam_id,duration,release_time
from examination_info eijoin(
select distinct exam_id,start_time,submit_time,
row_number() over(partition by exam_id order by timestampdiff(second,start_time,submit_time)) fast_2,
row_number() over(partition by exam_id order by timestampdiff(second,start_time,submit_time) desc) slow_2
from exam_record
where submit_time is not null) a
on ei.exam_id = a.exam_id
where fast_2 = 2 and slow_2 = 2
and (slow_2-fast_2)*2 > duration
order by ei.exam_id desc
金山WPS二面19人在聊